Word VBA and Excel

[Alan UK]

I wish to run an automacro(word open) to refresh documents
held on users "C" drive to master documents held on a
network drive. This I have successfully done.
HOWEVER!
These documents interact with an Excel spreadsheet that
should be refreshed in the same way. I would prefer to
carry out this process (something along the lines of
opening the master spreadsheet and saveas the "C" drive
location) within the word macro.
Is there any coding I could use to achieve this?

 

[Jay Freedman]

Hi Alan

See http://word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm.