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.
 
I think Vasant meant to say:

If you record your macros in 2000,
 
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.
 
Thanks for the timely correction, Deb and Tom!

Regards,

Vasant.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error when running an excel 2004 macro in excel 2000 2
Macro in Different Versions of Excel 4
New variables in 2002 vs. 2000 2
VBA Macro Versions 5
can't save my file with macro 2
Excel 2002, VBA, macros and Windows 7 1
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Win7 VirtualStore Weirdness with Excel 2002 and earlier 60

Back
Top