Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros in excel 2003 won't work in 2000
I have a workbook with several macros that works beautifullin 2003 but shows
errors in 2000. I had to save it as a template in order to share it with multiple users. What can I do so that the 2000 users will not have errors? Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros in excel 2003 won't work in 2000
You need to develop the code in the earliest version of Excel
that you are supporting. That means using Excel 2000, or at least not using any features that have been added since then. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "pywhacket" wrote in message ... I have a workbook with several macros that works beautifullin 2003 but shows errors in 2000. I had to save it as a template in order to share it with multiple users. What can I do so that the 2000 users will not have errors? Thank you! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros in excel 2003 won't work in 2000
You need to develope it in the lowest version of Excel that will run it.
Debug it in 2000 to make it work (mostly just removing features that did not exist in 2000). 2003 will be backwards compatible with 2000 (with a few minor exceptions like pivot tables code)... -- HTH... Jim Thomlinson "pywhacket" wrote: I have a workbook with several macros that works beautifullin 2003 but shows errors in 2000. I had to save it as a template in order to share it with multiple users. What can I do so that the 2000 users will not have errors? Thank you! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros in excel 2003 won't work in 2000
Thanks!
"Chip Pearson" wrote: You need to develop the code in the earliest version of Excel that you are supporting. That means using Excel 2000, or at least not using any features that have been added since then. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "pywhacket" wrote in message ... I have a workbook with several macros that works beautifullin 2003 but shows errors in 2000. I had to save it as a template in order to share it with multiple users. What can I do so that the 2000 users will not have errors? Thank you! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros in excel 2003 won't work in 2000
Thanks!
"Jim Thomlinson" wrote: You need to develope it in the lowest version of Excel that will run it. Debug it in 2000 to make it work (mostly just removing features that did not exist in 2000). 2003 will be backwards compatible with 2000 (with a few minor exceptions like pivot tables code)... -- HTH... Jim Thomlinson "pywhacket" wrote: I have a workbook with several macros that works beautifullin 2003 but shows errors in 2000. I had to save it as a template in order to share it with multiple users. What can I do so that the 2000 users will not have errors? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros created in 2003 won't work in 2000 | Excel Discussion (Misc queries) | |||
Macros won't work in 2000 that are created in 2003 | Excel Discussion (Misc queries) | |||
where did my old 2000 Excel macros go when I upgraded to 2003? | Excel Discussion (Misc queries) | |||
Excel 2003 macros don't work in Excel 2000 | Excel Programming | |||
Excel 2000 and 2003 VBA and Macros Incompatibility | Excel Programming |