backup file location

  • Thread starter Thread starter D Bogan
  • Start date Start date
D

D Bogan

Is there anyway to select which directory you want Excel
to place it's backup file. I would like to tell it to
backup somewhere's else besides the active directory. I
have windows 2000 with office 2000.
 
Actually there is no Save tab in Excel 2000's Tools, Options. And the
AutoRecover feature in Excel 2002 and 2003 has nothing to do with where the
XLK is saved in any case. I don't think we have any control over where
Excel saves the backup file. It seems to always be the current folder.
 
Here is a macro I use to make a backup directory for the active directory
You could modify to suit your needs.

Sub Backup() 'kept in personal.xls & assigned to toolbar button
On Error GoTo BackupFile
MkDir CurDir & "\Backup"
BackupFile:
With ActiveWorkbook
MyWB = .Path & "\BACKUP\" & .Name
.SaveCopyAs MyWB
.Save
End With
End Sub
 
Thanks

Deb
-----Original Message-----
Here is a macro I use to make a backup directory for the active directory
You could modify to suit your needs.

Sub Backup() 'kept in personal.xls & assigned to toolbar button
On Error GoTo BackupFile
MkDir CurDir & "\Backup"
BackupFile:
With ActiveWorkbook
MyWB = .Path & "\BACKUP\" & .Name
.SaveCopyAs MyWB
.Save
End With
End Sub





.
Click to expand...
 
Wish it was that easy. My tools options doesn't have a
save tab. But thanks anyways.
Deb
 
Yeah....I should stick to powerpoint!

Excel XP/2002 does have the "save" tab, but not Excel 2000.

Sorry
TAJ
 
Back
Top