Back-up

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have my workbook saving a back-up. I want to change
the location of the back-up. It currently saves to the
same location as the original workbook. I want to create
a seperate folder to save the back-up workbooks.

Thank you.
Tim
 
Hi Tim
you may post your existing code for amendmends. In general have a look
at
MkDir, ChDir, ChDrive
 
Tim

If you are speaking of the default backup folder used when "always create a
backup" from File>Save As>Tools>General Options..........

I don't believe there is a way to change this default.

If you are using a macro to save the current workbook and a backup, this works
for me.

Sub BUandSave2()
'Saves the current file to a backup folder and the default folder
'Note that any backup is overwritten
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs FileName:="E:\GordStuff\Backup\" & _
ActiveWorkbook.Name
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub

Gord Dibben Excel MVP
 
Thank you.
-----Original Message-----
Tim

If you are speaking of the default backup folder used when "always create a
backup" from File>Save As>Tools>General Options..........

I don't believe there is a way to change this default.

If you are using a macro to save the current workbook and a backup, this works
for me.

Sub BUandSave2()
'Saves the current file to a backup folder and the default folder
'Note that any backup is overwritten
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs
Click to expand...
FileName:="E:\GordStuff\Backup\" & _
 
Back
Top