Replies

Hi Macropod,

I put your macro into a blank word file and linked an excel sheet. I can see the data and everything is Ok. Once I close the word file and reopen it, and it auto runs the macro, I get an error that the excel file that I have linked is already open and you can’t have two of the same file name open. I’ll get this error a few times before it asks to End or Debug the VBA script. Excel isn’t running, but if I look at my task manager when I open the word file, I can see it start the Excel.exe process. When it eventually asks me to End or debug it shows it gets stuck at the OldPath NewPath line.

The weird thing is that if I force close the excel process 2 or 3 times when I first open the word file, it will actually update the link to the excel file like it is suppose to do. Am I doing something wrong?

Thank you