Nelson,
use late binding.
Here's a link to an Outlook example of converting from early to late binding
that I gave earlier this year
http://tinyurl.com/yhls
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Nelson" wrote in message
...
I have Excel files that are used by people with different
version of MS Office. These files create an Outlook object
and send emails.
The issue is, when a person with Outlook 2002 uses the
file, Excel is smart enough to switch to the Microsoft
Office 10.0 Object Library. However, next next person with
Outlook 2000 receives compile errors when the Excel code
runs. When I look at the references, it shows, MISSING
Microsoft Office 10.0 Object Library. I have to uncheck
that and recheck Microsoft Office 9.0 Object Library.
Is there anyway to handle this with code?
TIA
Nelson