VBA in Excel to operate word

H

HHH

In excel VBA I need to open up a particular word document, save it as a different name then step back into vba for excel. Can anyone right an example piece of code that works for this?
Thanks
 
D

Dave Peterson

If that's all you're doing, it might be easier just using filecopy.

FileCopy Source:="c:\myoldfolder\doc1.doc", _
Destination:="c:\mynewfolder\doc2.doc"
 
Top