bak file
Just for info.
The backup file is an XLK file, not a BAK
You could run beforesave event code to save a copy of the file(*.xls) to a
folder of your choice.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI _
As Boolean, Cancel As Boolean)
'Saves the current file to a backup folder and the default folder
'Note that any backup is overwritten
'New files must be saved twice before a backup is copied.
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs Filename:="C:\Gordstuff\" & _
ActiveWorkbook.Name
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub
Gord Dibben MS Excel MVP
On Fri, 16 Oct 2009 00:55:01 -0700, Yvonne007
wrote:
'Always Create Backup' file is saved on the source file's same directory.
There is no option to change the .bak file's save directory.
And I checked ADM File and support site, and Technet site, but I couldn't
find it.
In my opinion, it is impossible.
"Georg" wrote:
hi,
how can i change the directory of the bak-file. The xls file is stored on
the server, but i want to sve the bak file on a local pc . is this possible
?
regards, Georg
|