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
|