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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,489
Messages
5,837,661
Members
430,509
Latest member
steve85215

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