[johnnyy2k]

I am using Office 2003 and use code that references the Outlook reference library. The problem I am having is Outlook 2003 uses 11.0 and many of the users use Outlook 2000 which uses 9.0. Whenever I work with the spreadsheet is automatically updates the library to 11.0 and then my users get an error when they try to use the code. Does anyone know a trick or code to automatically select the appropriate library when the project is opened?

Thanking you in advance!

[cristobal03]

I'm assuming you're using early binding? I think you'd probably just have to add the earlier object library to your references. But that seems like a bad idea because they'd probably conflict, in which case the one set at the higher priority takes precedence (I think).

I don't know hardly anything about late binding, so I can't help you there.

chris.

[OBP]

I quote this from an Excel VBA programming book :-
You can add a reference programmatically using either of two methods of the Reference "class". AddFromfile adds a reference if you know it's file name and storage path.
AdFromGuid adds a reference if you know the reference's globally unique identifier, or GUID. Refer to the online help for complete details

[johnnyy2k]

I've been trying to get it to work. I think the ADDFROMGUID is the best option. Thanks!