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!

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



--
Regards,

Peo Sjoblom




"Eric" wrote in message
...
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!

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

On Thu, 30 Aug 2007 07:56:04 -0700, Eric wrote:

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!