I am working with a word document that has links to an excel workbook. I have tried this with task scheduler but it doesn't quite do what I need so I will play in this pond for a bit.
Basically, I need a vba that will open the excel file when the word file is opened. The excel file already has a code that will refresh the data and then automatically close the file after a minute. The goal is to open the excel file refresh that data, then refresh the data in the word document so it will be current and my boss will not have to mess with either file.
I have spent some time on this and any help would be appreciated.
-Adrian
Bookmarks