View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Need macro to work in 2000 and 2002 versions

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.

--
Regards,
Tom Ogilvy


Vasant Nanavati <vasantn *AT* aol *DOT* com wrote in message
...
If you record your macros in 2002, they will work for both versions. You
always want to develop in the lower version.

--

Vasant

"Fred Smith" wrote in message
...
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?

--
Thanks,
Fred
Please reply to newsgroup, not e-mail