Remove missing reference, update outlook reference

Hello,

I have an excel xlsm file which includes Microsoft outlook reference.
The file is opened in excel 2007 and excel 2010.

When the file is opened in Excel 2007 after it is opened in Excel 2010
I get a reference error message and a missing reference.

I wish to dynamic update the reference - remove the missing outlook reference and add the correct one.

I use the following code. If the reference is missing it adds it correctly.
My problem: when there is a missing reference the code can not remove it and I get an error.

Can you help me ?

Thank you for your help

Please Login or Register  to view this content.

Hello Snoopy2003,

You can easily resolve this problem by using late binding in your code. The downside is you can not use named constants from the object library and you do not have the Intellisense to show you the various properties and methods of the object. The upside is you do not have to fiddle about with checking for and loading the correct library and removing missing references.

Late Binding Example for Outlook

Please Login or Register  to view this content.

Hello Snoopy2003,

Named constants are usually prefixed with ol. Here is an example of the predefined named constants for the Default Folders. To find the constants for Outlook use the Object Browser in the Visual Basic Editor by pressing F2.

Outlook Default Folder Constants and Values

Please Login or Register  to view this content.