Save document to multiple locations
 

Other than repeatedly using Save As or Copy and Paste, is there a way to
save a document to multiple locations?

Save document to multiple locations
 

See the "Name" statement in help.
As long as each file goes in a separate folder then...

Dim OldName As String
Dim NewName As String
OldName = "C:\MyFolder\OldFile.xls"
NewName = "C:\YourFolder\OldFile.xls"
Name OldName As NewName

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware




(Excel Add-ins / Excel Programming)
"Bob" wrote in message
Other than repeatedly using Save As or Copy and Paste, is there a way to
save a document to multiple locations?