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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top