bak file

[Georg]

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

 

[Yvonne007]

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

 

[Gord Dibben]

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