Hi, I have an excel macro that needs to open a word document, update links in the word doc (the links are to the excel file that the macro is in) and then run its own word macro.

Right now I am running the excel macro, then opening word, manually updating the links, and then running the word macro. I want it all to be done at once when I run the 1st macro (the one in excel). Can anybody give me an idea on how to do this? It doesn't write anything when I record a new macro and perform these actions.