EXcel 2000 pro auto backup location
 

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?

EXcel 2000 pro auto backup location
 

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?

EXcel 2000 pro auto backup location
 

Thats amazing info.

Is this when using Active safe , or just for Excell 2000 alone?

Im fairly careful when it comes to installing and using new addins.

one last question

edit file path is that C: gordstuff etc etc in copy paste code?

"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?