saveas for backup

  • Thread starter Thread starter dickminter
  • Start date Start date
D

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
 
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)
 
Back
Top