Backup files in separate directory?
 

Is there no way to get Excel to put .XLK files in a different
directory from .XLS files? (E97)

TIA,


--
Martyn Tindall
Leeds, England, United Kingdom

(To reply, please remove "spamfree.".)

Backup files in separate directory?
 

Nope.

But you could create a macro that would save the workbook and save a copy.

Something like:

Option Explicit
Sub testme()
With ActiveWorkbook
.Save
.SaveCopyAs Filename:="C:\my backups\" & .Name
End With
End Sub



Martyn B Tindall wrote:

Is there no way to get Excel to put .XLK files in a different
directory from .XLS files? (E97)

TIA,

--
Martyn Tindall
Leeds, England, United Kingdom

(To reply, please remove "spamfree.".)

--

Dave Peterson