Reference Outlook in Excel2003, but not working in Excel2000.

J

jchen

Hello,
I made a macro 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.

But, 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