can I choose office to create a backup file on another drive?
Can I have Excel create a backup of my document automaticaly to my chosen
location? I know previous versions used to create a backup on the same directory as the original document. |
Jamo
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 Thu, 27 Jan 2005 01:51:04 -0800, "Jamo" wrote: Can I have Excel create a backup of my document automaticaly to my chosen location? I know previous versions used to create a backup on the same directory as the original document. |
All times are GMT +1. The time now is 11:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com