I just got the latest hotfix and was happy to see the ability to copy worksheets has been added - thank you!
I have, however, run into a problem.
Here is the general idea of what I am doing:
* I am generating individual reports one at a time while looping through a datasource
* The individual reports (Excel objects) get saved
* As I am creating the individual reports, I copy the worksheets from each individual report into a "batch" report (Excel object)
* I now notice, that, after calling:
That the Worksheets seem to be gone at this point? I have verified this by seeing that myExcel.Worksheets.Count == 1 when it was 2, and the Sheet names are all gone.
Am I improperly calling save() in this instance?
Thanks in advance for the help.