backup file location

[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.

 

[TAJ Simmons]

Deborah,

Try tools > options > then click the "save" tab to edit the directory

Cheers
TAJ Simmons
microsoft powerpoint mvp

awesome - powerpoint backgrounds,
free sample templates, tutorials, hints and tips etc
http://www.powerpointbackgrounds.com

 

[Jim Rech]

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.

 

[Don Guillett]

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

 

[D. Bogan]

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





.

 

[D. Bogan]

Wish it was that easy. My tools options doesn't have a
save tab. But thanks anyways.
Deb

 

[TAJ Simmons]

Yeah....I should stick to powerpoint!

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

Sorry
TAJ