Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Issue with UsedRange.Copy (code works in Excel 2002) | Excel Programming | |||
Code works with Excel 2000 but not with Excel 2002 | Excel Programming | |||
Code works with Excel 2000 but not with Excel 2002 | Excel Programming | |||
Code works with Excel 2000 but not with Excel 2002 | Excel Programming | |||
code works in excel 2002, but not in excel 2003 | Excel Programming |