Excel 2000 VBA App Now Works in Excel 2003, but not Excel 2002
 

I have a VBA app that I originally wrote in Excel 2000. Someone who
had Excel 2003 tried it and found compile errors. I downloaded a
trial version of Excel 2003 and debugged the app. I found that the
problem was a Calendar control that was available in Excel 2000, but no
longer supported in Excel 2003. I replaced the Calendar control with
the new Date Picker control, and the app is working in Excel 2003.

But I had another person the new version with Excel 2002, and that
person is not able to run the app due to compile errors as well. That
person is coming up with a "Can't find project or library" compile
error. This error message seem similar to the error I was originally
seeing when I tried to run the original Excel 2000 app in Excel 2003.
Also, when forcing a step over, the error seems to be pointing to a
"Format" statement on a date. However, I know from debugging the code
for Excel 2003 that the problem is probably not the "Format" statement,
but rather the Calendar control I was using. I don't understand what
causing the problem now in Excel 2002. Does Excel 2002 support a Date
Picker control?

Thanks in advance.