I have users in both Excel 2003 and 2000 (in the midst of upgrading all users). A developer upgraded his version to 2003. The application makes heavy use of macros and uses the Object Libraries. When the developer saves the file, it upgrades the references to Office 11.0 Object Library. When the users in Excel 2000 open the file and the macros execute, it cannot find that library (uses 9.0 Object Libary) and the application exits.
While it would be possible to have the developer go back to office 2000, this is the third time I've been asked to address this problem. The company I am working with has 40,000 pc's and the migration from Office 2000 to Office 2003 will take some time.
Is there any solution that can be placed in a macro to ensure the right library is referenced? The solution of having the users change the reference manually is not acceptable. (Some users barely can open the file, let alone go into VBA, Tools, References and sort through all the selections!)
Thank you for any assistance, hints or guesses you can send my way,