Save copy of file in other folder

[lfmemp]

Hello everybody,

I do have a file in which I have a macro that closes and saves the file, if the user is running the macro. The file is saved under the specified folder it is located. The code is as follows:

Please Login or Register  to view this content.

I would now like, apart from the above, which works fine, to also save a copy of that file in another location (another folder on my drive).
Can the above macro also include a command to save a copy of this file in another location?

Thank you

[JOHN H. DAVIS]

Just add another SaveAs line:

Please Login or Register  to view this content.

[lfmemp]

Thank you for your response.

I am afraid, the above is somehow not working though. I change the pathname to the location I want to save in addition the copy of the file, but it is only saved to its original location. No copy is saved to the new path.

Thank you

[JOHN H. DAVIS]

It should work. Try putting it in the with statement.

Please Login or Register  to view this content.

[lfmemp]

It seems like it is saving the file, but it changes the file name to the path that I am entering, in this case "C:\YOUR DESTINATION".

I need it to save a copy of the file and keep the same file name. The saving should be done in another folder.

Say, the name of the file is "MyFile"
I want it to save "MyFile" in C:\All Files\Master
and a copy of "MyFile" in C:\All Files\Project1
The name "MyFile" should not be changed.

thank you

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.