Gord

I see that this worked for the other user, however I am not familiar with
VB. So if you could give me some more direction on where this code should go.

Thanks

"Gord Dibben" wrote:

Luke

Sub BUandSave()
'Saves the current file to a backup folder and the default folder
'Note that any backup is overwritten
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs FileName:="C:\yourfolderf\" & _
ActiveWorkbook.Name
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub


Gord Dibben MS Excel MVP

On Fri, 22 Dec 2006 21:55:00 -0800, Luke Slotwinski
wrote:

I am seeking to save a workbook in two places, having the second save
automatic.
In detail: I'd like to be able to specify the save location of the Save
request, but I'd like to automatically save a copy (or a backup) in another
folder on another drive... is this possible?