VBA in Excel to operate word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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"
 
Back
Top