This event code will save the current file to the default location and a
specified location when you close the workbook.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
'Note that any previous backup is overwritten
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs Filename:="C:\Gordstuff\" & _
ActiveWorkbook.Name
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub

Right-click on the Excel Icon left od "file" on the menubar.

Select "View Code"

Copy/paste the code into that module.

Edit the path the Alt + q to return to the Excel window.


Gord Dibben MS Excel MVP

On Mon, 12 Jan 2009 06:01:00 -0800, Tazzer
wrote:

I was wondering if there was a way to choose the location of the auto back up
file to a directory or seperate out board drive through the app.

I have looked at an add in Auto safe but that seems to only be useful until
it deletes the the backup upon closing the worksheet.

I basically lazy and would like to save a clone file to a seperate location
when I've finished working rather than doing it twice.

Any ideas?