Hi,

I have an Excel VBA file that uses the Microsoft Outlook 10.0 Object Library. The problem I am having is this..... When someone opens the file with a newer version (11.0) of the object library then saves it, then a person with the older version (10.0) opens the file and tries to run the macro it gives them an error because it shows in the references that the 11.0 library is missing. So, you have to go in and uncheck the missing 11.0 library and check the 10.0 library.

Is there a way to check for missing references in the workbook.open() event and switch the references to the appropriate library through code?

Any help would be appreciated. Thank you!