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

Use SaveCopyAs instead.

--
Regards,
Tom Ogilvy

wrote in
message ...
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

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)

" wrote in
message ...
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