There are many ways to do this. Have you thought of using saveas or sheet
copy?

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