Saving a workbook into a new directory

RoyR

Board Regular
Joined
Jan 25, 2012
Messages
62
I have a macro that saves my workbooks into a backup directory. The problem with it is on each backup, it over writes the old backup. So I thought I would make a new macro to create a new directory and save the files there thus leaving the old backup intact. The problem is getting the files into the new directory. Here is a sample of the code I am using.

Code:
MkDir "C:\MovieDB\Backup\Backup on  " & Format(Now(), "mm_dd_yyyy hh mm AMPM")
NewDir = "C:\MovieDB\Backup\Backup on  " & Format(Now(), "mm_dd_yyyy hh mm AMPM")
ActiveWorkbook.SaveCopyAs "NewDir\MovieDB.xls"

The last line is not working and I have tried many variations of it but can't seem to get it right. I can get it to save a copy with both the new directory and the file name combined, but not get it into the newly created directory.

Any ideas?
Thankyou in advance.
Roy
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

RoyR

Board Regular
Joined
Jan 25, 2012
Messages
62
Figgured it out. The last line needs to be as follows:

Code:
ActiveWorkbook.SaveAs NewDir & "\MovieDB.xls"

Thanks to those who took the time to have a look
 

Watch MrExcel Video

Forum statistics

Threads
1,129,593
Messages
5,637,294
Members
416,963
Latest member
zazama

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top