Modify Macro To Save In To Another Folder

[JimmiOO]

Hi

Can someone please help me with this?

I have a macro listed below, all the maco does is save a back up of the file i am saving just incase the file gets overwritten by mistake.

At the moment the back up file saves to the same directory as the workbook being saved, i would like it to save to a folder in the same directory called "Back Up" but i am having problems doing this. I do not want to put in the C:\Directory\Filename all i want to do is save to the folder "Back Up" in the same directory as the orig file no matter where it is.

Please Login or Register  to view this content.

[jaslake]

Hi JimmiOO

Something like this may work

Please Login or Register  to view this content.

Hope this helps.

John

[JBeaucaire]

Perhaps the SaveCopyAs method?

Please Login or Register  to view this content.

[JimmiOO]

Hi JimmiOO

Something like this may work

Please Login or Register  to view this content.

Hope this helps.

John

Hi John i tried to fit this into my code but can,t get it to work properly, could be putting it in the wrong place

[JBeaucaire]

If you use SaveAs, you are changing the name of the active workbook. To go back to editing the original file you would have to close the wb and reopen the other copy.

Using the SaveCopyAs method would give you a backup copy without changing the current active workbook name/location so you can keep working with no issue.

[jaslake]

Hi JimmiOO

This worked for me

Please Login or Register  to view this content.

John

[jaslake]

Hi JimmiOO

I think JB's approach is the way to go. The revised macro I posted works fine the first time around in the same session but not the second time around in the same session.

John

[jaslake]

Hi JimmiOO

Using JB's recommendation, your code would look something like this

Please Login or Register  to view this content.

It's been tested.
John