I want to do the following:
-Open Workbook A
-Create 2 copies of Workbook A (I'll name them Workbook B & C).
-Modify Workbooks B & C slightly
-Save all 3 workbooks.
I'm running into trouble creating copies of workbook A. If I use the WB.SaveAs method, I can create Workbook B, but Workbook A is now closed.
Is there a way to create a copy of a workbook without losing the original workbook?
Thanks,