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.