View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default 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