How do I ref OutlookCOM in my Excel2003 PC and run it on Excel2000

J

jchen

Hello,
I made a macro (in Excel 2003) to send emails based on the data from Excel
Worksheet. The macro resides in excel file and using outlook COM object. It
works fine in Excel2003, but totally failed in Excel2000.

I know that some code doesn't run on older excel or outlook objects, so I
made sure the syntax is backward compatible. And both Excel2000 and
Outlook2000 are installed on the PC.

Still, my macro failed to compile in Excel2000. It seems like there is a
reference conflic; the well known library version problem. Do you know how do
I get around it?

Why does my code compiles in both Excel2000 and 2003 if I didn't reference
extra library? Can I reference Outlook COM based on the user's computer
library version? Anyway to solve this problem?

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top