Is there no way to get Excel to put .XLK files in a different directory from .XLS files? (E97) TIA,
M Martyn B Tindall Nov 30, 2005 #1 Is there no way to get Excel to put .XLK files in a different directory from .XLS files? (E97) TIA,
D Dave Peterson Dec 1, 2005 #2 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
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
