Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 vs 2000 VBA Compatibilty
I coded a VBA app in Excel 2003. Runs fine. But not when run with
Excel 2000. For example, a dialogue box selection launches a subroutine that sorts a range. An error message appears running 2000: Compile error. Can't find project or library. BTW, the sort routine was captured via a macro. So I am not sure if there are some new parameter settings in 2003 that are not recognized by 2000. Are there any fundamental downward compatibility issues with 2003 vs. 2000? Any assistance appreciated. SteveM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 vs 2000 VBA Compatibilty
Hi Steve
You probably have something like DataOption1:=xlSortNormal at the end of your macro These options DataOption1 to 3 were added in XL2003 and can be safely removed without stopping the macro continuing to work in 2003. -- Regards Roger Govier "SteveM" wrote in message ups.com... I coded a VBA app in Excel 2003. Runs fine. But not when run with Excel 2000. For example, a dialogue box selection launches a subroutine that sorts a range. An error message appears running 2000: Compile error. Can't find project or library. BTW, the sort routine was captured via a macro. So I am not sure if there are some new parameter settings in 2003 that are not recognized by 2000. Are there any fundamental downward compatibility issues with 2003 vs. 2000? Any assistance appreciated. SteveM |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 vs 2000 VBA Compatibilty
Hi Steve,
In VBA editor go to tools refrences and uncheck all the refrences you are not using.I think the problem is with the missing refrences Thanks Xcelion "SteveM" wrote: I coded a VBA app in Excel 2003. Runs fine. But not when run with Excel 2000. For example, a dialogue box selection launches a subroutine that sorts a range. An error message appears running 2000: Compile error. Can't find project or library. BTW, the sort routine was captured via a macro. So I am not sure if there are some new parameter settings in 2003 that are not recognized by 2000. Are there any fundamental downward compatibility issues with 2003 vs. 2000? Any assistance appreciated. SteveM |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 vs 2000 VBA Compatibilty
Roger and Xcelion,
Thanks much to you both. SteveM Xcelion wrote: Hi Steve, In VBA editor go to tools refrences and uncheck all the refrences you are not using.I think the problem is with the missing refrences Thanks Xcelion "SteveM" wrote: I coded a VBA app in Excel 2003. Runs fine. But not when run with Excel 2000. For example, a dialogue box selection launches a subroutine that sorts a range. An error message appears running 2000: Compile error. Can't find project or library. BTW, the sort routine was captured via a macro. So I am not sure if there are some new parameter settings in 2003 that are not recognized by 2000. Are there any fundamental downward compatibility issues with 2003 vs. 2000? Any assistance appreciated. SteveM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving excel files in compatibilty mode | Excel Discussion (Misc queries) | |||
Excel file in compatibilty mode and not all sheets within the fil. | Excel Worksheet Functions | |||
Excel 2007 Macros compatibilty with earlier versions!! | Excel Discussion (Misc queries) | |||
English date format and compatibilty with others Excel Language | Excel Discussion (Misc queries) | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) |