View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Need macro to work in 2000 and 2002 versions

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