Need macro to work in 2000 and 2002 versions

  • Thread starter Thread starter Fred Smith
  • Start date Start date
F

Fred Smith

I'm developing macros on a computer with Excel XP (2002). They will need to
run on computers which have only Excel 2000.

When I record macros, sometimes I get statements that only work in XP. Is
there any switch I can set to tell Excel to dumb down its code generated to
the 2000 version?
 
If you record your macros in 2002, they will work for both versions. You
always want to develop in the lower version.
 
Obviously Vasant meant to record them in xl2000. There is no way to dumb
them down except if you do it yourself by testing them in xl2000 and compare
the argument list in the help to what you have when an error is raised.
There is no record in compatibility mode specifying xl2000.
 
Back
Top