Hi guys,
Created an application that was worwing perfectly fine with Excel 2007 but now I am encountering a few erros with 2010.
One of them goes as follows:
The macro opens a number of workbooks, copies data from certain ranges into the workbook where the macro resides and then closes the "data suppliers" workbooks.
With 2007 all workbooks were opened and closed with no errors. In 2010, the macro raises an error "object invoked has disconnected from its clients" when attempting to close a couple of workbooks. All workbooks were created using the same template and have a large Excel table in one of the sheets . The two workbooks that make Excel crash do not have any data on the table, just a unique and empty row and of course the table headers. If I happen to enter a new row on the table, then it will not crash. If I enter data on some of the fields of that unique row it may crash or not, depending on which fields are filled. Really weird.
So it is the table that it is causing these errors. If I remove it Excel closes the file fine.
I am not going to bother posting the code as I have removed absolutely everything for testing purposes reducing it to a simple open workbook and close workbook lines and Excel is still crashing.
Any suggestions?
Thanks very much.
Bookmarks