Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using macros on different versions of Excel
I am creating Excel sheets that are used on computers running different
versions (2000 onwards) of Excel and different language versions. Using Excel 2003 for creating the sheets and recording/modifying the VBA code, I get results that work perfectly well when I test them on Excel 2003. However, some of the macros generate errors when run on other Excel versions? Is there a way to know, without sending the files for a trials to the users and without having access to all previous versions for testing, to know the common denominator scripts that work on Excel 2000 onwards. My problems are mainly with - Hide/Unhide sheets - Paste Special Values - Sorting |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using macros on different versions of Excel
I don't know that there is a general dictionary of compatability issues. I
have run into the same problem where I work. I generally find a computer with xl2000 and test the code. If I need to make any changes I make them on the that computer as the newer versions of xl are generally backwards compatible. With the problems you have listed there have been no major changes just minor syntax changes. Without more info this is the best answer I can give. If you want to post examples of what is not working we can see about testing and giving the correct syntaxes. "AndersW" wrote: I am creating Excel sheets that are used on computers running different versions (2000 onwards) of Excel and different language versions. Using Excel 2003 for creating the sheets and recording/modifying the VBA code, I get results that work perfectly well when I test them on Excel 2003. However, some of the macros generate errors when run on other Excel versions? Is there a way to know, without sending the files for a trials to the users and without having access to all previous versions for testing, to know the common denominator scripts that work on Excel 2000 onwards. My problems are mainly with - Hide/Unhide sheets - Paste Special Values - Sorting |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macros compatibilty with earlier versions!! | Excel Discussion (Misc queries) | |||
Menu/toolbars/macros defined in Excel 2003 not working in other versions? | Excel Programming | |||
How to make the macros work for different Excel versions? | Excel Programming | |||
VB code needed for running newer excel version macros in older excel versions | Excel Programming | |||
Code for runnning macros created in XP in older excel versions | Excel Programming |