I have an Excel file used by people with different version
of MS Office. The file creates an Outlook object for
sending emails.

The issue is, when a person with Office 2002 uses the
Excel file, Excel is smart enough to switch to the
Microsoft Office 10.0 object library. However, when the
next user has Office 2000, Excel does not switch back to
the Microsoft Office 9.0 object library.

Compile errors occur and when I look at the references it
says MISSING Microsoft Office 10.0 object library. I have
to uncheck that one and recheck the Microsoft Office 9.0
object library.

Is there a way to handle this problem with code?

TIA
Nelson

Duplicate post, sorry

-----Original Message-----
I have an Excel file used by people with different
version
of MS Office. The file creates an Outlook object for
sending emails.

The issue is, when a person with Office 2002 uses the
Excel file, Excel is smart enough to switch to the
Microsoft Office 10.0 object library. However, when the
next user has Office 2000, Excel does not switch back to
the Microsoft Office 9.0 object library.

Compile errors occur and when I look at the references it
says MISSING Microsoft Office 10.0 object library. I have
to uncheck that one and recheck the Microsoft Office 9.0
object library.

Is there a way to handle this problem with code?

TIA
Nelson
.