Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Saving excel backup copy - path?
When checking the setting in the Save As Options "always create backup", By
default excel saves the backup copy to the same path as the original file. Can this backup file be saved to another path? if so, where can I make this change? File - Save AS - Tools - General Options - Always create backup. thanks, |
#2
|
|||
|
|||
ac
Not as far as I know. Backups are saved in the Excel default file location. You could create a macro that will save the file at the default location and a copy to the folder of your choice. The macro could be run manually or in beforesave code in ThisWorkbook. Sub BUandSave2() 'Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) '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 On Fri, 4 Feb 2005 09:51:02 -0800, "ac" wrote: When checking the setting in the Save As Options "always create backup", By default excel saves the backup copy to the same path as the original file. Can this backup file be saved to another path? if so, where can I make this change? File - Save AS - Tools - General Options - Always create backup. thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Automatic backup copy | Charts and Charting in Excel | |||
Backup in Saving a file in Excel 2002 | Excel Discussion (Misc queries) | |||
How do i save backup copy in a different folder | Excel Discussion (Misc queries) | |||
Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) |