B Bob Jan 19, 2008 #1 Other than repeatedly using Save As or Copy and Paste, is there a way to save a 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?
J Jim Cone Jan 19, 2008 #2 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?
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?
