MacDaddy
05-24-2010, 01:44 AM
I'm attempting to 'upgrade' a file from Excel 2000 to Excel 2007. The file contains many macros which don't work under 2007.
When I try to run any of the macros I receive the error message: "Object library invalid or contains references to object definitions that could not be found".
I have checked the references under both 2000 and 2007 and the only differences are that the 2000 version uses Microsoft Excel 9.0 Object Library and Microsoft Office 9.0 Object Library whereas under Excel 2007 it's using Microsoft Excel 12.0 Object Library and Microsoft Office 12.0 Object Library.
Is this causing the problem and if it is why are the later versions of these object libraries not backward compatible with earlier versions?
Thanks in advance,
Paul
When I try to run any of the macros I receive the error message: "Object library invalid or contains references to object definitions that could not be found".
I have checked the references under both 2000 and 2007 and the only differences are that the 2000 version uses Microsoft Excel 9.0 Object Library and Microsoft Office 9.0 Object Library whereas under Excel 2007 it's using Microsoft Excel 12.0 Object Library and Microsoft Office 12.0 Object Library.
Is this causing the problem and if it is why are the later versions of these object libraries not backward compatible with earlier versions?
Thanks in advance,
Paul