Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Outlook in Excel2003, but not working in Excel2000.
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening .csv file in Excel2003 vs Excel2000 | Excel Discussion (Misc queries) | |||
How can I use autosave from excel2000 in excel2003 | Excel Worksheet Functions | |||
Time needed for the group function: big diff between Excel2003 and Excel2000 | Excel Programming | |||
excel2000 owc doesn't work on excel2003 ! | Excel Discussion (Misc queries) | |||
Can't open Excel2003 workbook containing VBA macros with Excel2000. | Excel Programming |