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)
in message
Other than repeatedly using Save As or Copy and Paste, is there a way to
save a document to multiple locations?
