Save in mulitple locations

A

Aversin

Is there a way to have excel xp auto save in multiple locations a
once?
ie....save a copy on my desktop and save on a network drive at the sam
time, and a way to have excel do this by itself every 5 mins or s
 
G

Guest

you can autosave it to your c drive. the icon on your
desktop is just a shortcut to the c drive.
to autosave...tools>autosave. check autosave, enter
minutes.
if autosave is not on the tool bar, you will have to add
it....tools>Add-in. check autosave.
there is no option for multiple saves. this can be done
only by macro.
 
G

Gord Dibben

Aversin

XL2002 and 2003....have Autorecovery, which does not make incremental saves
but if Excel crashes you can recover the file to the last spot in the
autorecovery cycle(you can set that in Tools>Options>Save). If Excel does not
crash, the autorecovery temp file is deleted when workbook is closed.

Earlier versions had an Autosave add-in which made incremental saves at the
time of your choosing. Once saved, there is no going back.

But........saved in one folder only.

The AUTOSAVE.XLA from earlier versions works fine with Excel 2002.

I have tried the version from Excel 97 and it works fine.

If you want a timed backup to separate folders at intervals you would be
forced to use VBA code.

Here is some code that saves the current open workbook in the default folder
and in a backup folder.

Sub BUandSave2()
'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

Just add OnTime code to have it run at timed intervals.

For OnTime code see Chip Pearson's site.

http://www.cpearson.com/excel/ontime.htm


Gord Dibben Excel MVP
 
Top