saveas for backup

[dickminter]

What's the difference between using Save vs SaveAs
with "createbackup" set to true? How do I execute Saveas
to a backup file (different workbook name) and have Excel
not replace the active workbook with the saved file?

DM

 

[Tom Ogilvy]

Use SaveCopyAs instead.

 

[Bob Phillips]

Save saves the workbook under its existing name.

SaveAs saves it under the specified name. Createbackup create a .bak file at
the save time.

Use SaveCopyAs to create a copy but leave the activeworkbook unaffected.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)