Saving one file in two different places

J

john doe

I'm looking for a macro that will save one file in two different places.
Please advise.
Thanks
 
J

Jonathan West

john doe said:
I'm looking for a macro that will save one file in two different places.
Please advise.
Thanks
Click to expand...

Write a macro that does ActiveDocument.SaveAs twice, with two different
values for the Filename parameter.

Alternatively, simply save the document using ActiveDocument.Save and then
copy it to another folder using the technique described in this article

How to copy an open file using VBA
http://www.word.mvps.org/FAQs/MacrosVBA/CopyOpenFile.htm


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
 
J

john doe

Thanks guys.
It worked perfectly.
I also changed the Word macro to a Excel macro
and I'm using it to back up my Excel files.
Instead of ActiveDocument is use ActiveWorkbook

Thanks
 
H

Helmut Weber

Hi Greg,

I expected an excursus on that no two things
can be on the same place, or was it, that no thing
can be on two different places? ;-)

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"
 

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

Similar Threads

Sub projects added as read only in Master file which are saved on sharepoint 1
Create a dynamic master file 1
Corrupt? Scrolling while viewing two pages side by side, pages go wonky? 0
Annotation Yellow Dot in BPMN seems to be centred in one place 0
Images are pixelated when saving to PDF 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Template location changes from user to user 0
Excel file won't save to iCloud on Mac 0

Top