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.

Distribute with a reference set to the lowest version of Outlook of any of
your users.

If the file is subsequently saved on a later version, it will no longer work
on an earlier version. If this is a possible scenario convert to Late
binding.

Regards,
Peter T

"jchen" wrote in message
...
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.