Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 Macro in Excel 2000 Environment
I have Excel 2003 macro but have a customer who still uses Excel 2000. Is
there a way in Excel 2003 to run the macro that simulates the Excel 2000 environment? My customer previously tried to run the macro but received an error message. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 Macro in Excel 2000 Environment
The only truely safe way is to create the macro in 2000. That code will be
forwards compatible (except pivot table code). 2003 is not backwards compatible. Here are some of the usual culprets however... References - One of the big one is ActiveX Data Objects 2.8 library Pivot tables - code for pivot tables was fundamentally changed for 2002. That code requres a major rewrite between versions as the data engine changed. Sorting - A couple of extra paramters were added in 2002 xlSortDataOption. This prameter can noramlly be deleted as it is normally xlSortNormal. -- HTH... Jim Thomlinson "fatherof5clones" wrote: I have Excel 2003 macro but have a customer who still uses Excel 2000. Is there a way in Excel 2003 to run the macro that simulates the Excel 2000 environment? My customer previously tried to run the macro but received an error message. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 Macro in Excel 2000 Environment
You have to remove the offending line of code, which must refer to something
added to VBA after Excel 2000. There's no "environment" to simulate. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "fatherof5clones" wrote in message ... I have Excel 2003 macro but have a customer who still uses Excel 2000. Is there a way in Excel 2003 to run the macro that simulates the Excel 2000 environment? My customer previously tried to run the macro but received an error message. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify Excel (2003) code for Network environment | Setting up and Configuration of Excel | |||
Run time error : Excel 2000 and Excel 2003 : different behavior of Macro | Excel Programming | |||
Excel 2000 very unstable as a development environment | Excel Programming | |||
Excel 2000 microsoft development environment | Excel Programming | |||
Excel 2002 VBA App fails in Excel 2000 Environment | Excel Programming |