If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
bak file
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 |
#2
|
|||
|
|||
bak file
'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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|