Hi Sylvia,
I need to read an excel file and do some modifications and save this file into different location. Along with this I need to remove the extra sheets which is not used by the program. For this I wrote a method inside calling workbook.removeSheetAt(index). This works fine without any exception.
The problem now is whenever I tried opened the newly created worksheet it is showing a Removed one or more invalid names repair message box.
How can you say it is working fine? Because after you do your modifications (including the deletion of unwanted worksheets) if you are not able to check the worksheet how can you say it is working?
My assumption is your modification of the worksheet is working ok and you are probably able to copy it to a new location too. But after deleting unwanted worksheets from the original document you are not able to open the second one?
My thought goes like this, since the two documents are two completely seperate entities why should a deletion of worksheets from one cause an error while opening the other? Unless they are related in some possible manner, which is why I asked the ExcelDocument question. May sound childlike but are you sure you are opening and closing the documents correctly?
Cheers,
Raj.