Need macro to work in 2000 and 2002 versions
 

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

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

Need macro to work in 2000 and 2002 versions
 

I think Vasant meant to say:

If you record your macros in 2000,


Vasant Nanavati wrote:
If you record your macros in 2002, they will work for both versions. You
always want to develop in the lower version.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

Need macro to work in 2000 and 2002 versions
 

Thanks for the timely correction, Deb and Tom!

Regards,

Vasant.

"Tom Ogilvy" wrote in message
...
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