make backup excel

[Guest]

I'd like to make a backup of an Excel file, but NOT in the same folder. I'd
like to make a true backup, not in the location of my original file but on
another physical drive.
So I don't mean the auto backup function which saves the backup in the same
folder as the original...

It's possible in Word, but I can't find it in Excel.
If someone can help would be great!

 

[Peo Sjoblom]

Get Jan Karel Pieterse's autosafe, it will do what you want I believe

http://www.jkp-ads.com/Download.asp


There are some other nice utilities there as well

 

[Gord Dibben]

Try this macro.

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:\mybackups\" & _
ActiveWorkbook.Name
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub


Gord Dibben MS Excel MVP