View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roy[_4_] Roy[_4_] is offline
external usenet poster
 
Posts: 1
Default "Backing" up a Workbook Sheet

I'm developing an Excel-based VBA program that performs
some calculations and updates on a master budget sheet.

However, before I allow the user to go modifying this
sheet, I would like to "back it up" to a new Excel
spreadsheet in the very-likely event I have to correct
their errors.

How do you copy/export/backup the entire workbook and/or
selected sheets to a new Excel workbook?

Thanks in advance for your help!