Problems with saving workbooks

[Raj]

Hi,

Workbook1 has 2 worksheets to start with and a macro. When the macro
is run, the two sheets are populated with data(imported from other
workbooks) and 5 new sheets are added. The macro also has code to save
Workbook1 as Workbook2 with a date and time stamp. I need Workbook1 to
retain its original state: viz. 2 worksheets and a macro so that it is
reusable. Unfortunately, the imported data and the added sheets are
all being retained in Workbook1. How can I retain the original state
or undo all changes done to Workbook1


Thanks in advance for the help.

Regards,
Raj

 

[JLGWhiz]

Close it without saving any of the new data or sheets. If you can't do that
because you need to save it after the new sheets are added, then when you
open it to add the new sheets, immediately do a SaveAs under a new file name
then proceed with all the sheet and data updates. Your original file will
not be affected.

 

[JLGWhiz]

There is a potential problem in using the suggestions from my previous
posting. Your macros might need to be updated if they use the workbook name
anywhere in them.