Hi,
I am using XLSIO to add a worksheet, delete a worksheet multiple times from a workbook (Excel file). In my application, the same Excel file will be opened and closed multiple times to add or delete a worksheet.
The code works fine for the first 5 times or so and then I get the following error:
"Error adding Excel report - offset and length were out of bounds for the array or count is greater than the number of the elements from index to the end of the source collection."
See attached file with the code for adding the Excel and deleting the worksheet or file.
Any help would be great!!
Thanks!
Test86.zip