Toggle Help Topics Menu >

Save a Backup Copy of Workbook

Saves a backup copy of the workbook to the same folder where the workbook is located. A timestamp is added to the end of the file name in the form yyyy-MM-dd-HHmmss, where:

  • yyyy = 4-digit year.
  • MM = month (01-12).
  • dd = day (01-31).
  • HH = hour (00-23)
  • mm = minute (00-59)
  • ss = seconds (00-59)

After saving, a message box will confirm the file save and display the time stamped file name.