VB code needed for running newer excel version macros in older excel versions

[Tom]

Hi all,

When trying to run a macro, created in excel XP, on a pc
with excel 2000 installed, the macro will find codes that
are not recognized in the older excel versions and
therefore not finish running. Is there any (simple) coding
available to avoid these problems from happening?

Thanks,
Tom

 

[tom]

is there another way then creating the macro in the older
excel version? this takes tooo long (e.g. siable the
feature in excel 2000?

 

[Howard Kaikow]

You need to eliminate the use of features of Excel 2002 VBA not supported by
Excel 2000 VBA.
One way to do this is to develop the code using Excel 2000, instead of Excel
2002.

 

[Keith Willshaw]

is there another way then creating the macro in the older
excel version? this takes tooo long (e.g. siable the
feature in excel 2000?

Just do a save as into Excel 2000 format and
open Excel 2000 , you should get the errors
when you compile

It that doesnt work export the code modules from 2002
and load em into 2000

Keith

 

[Tom Ogilvy]

there is no difference in formats since xl97.

Getting the compile errors is what he is getting now. He wants some
automatic way to fix them - I don't believe there is a way to do that.

 

[Howard Kaikow]

It depends on what features of Excel 2002 are being used and how the code is
structured.

The safest way is to do the development in Excel 2000.

 

[Howard Kaikow]

He could program around them, by isolating the 2002 code in modules that do
not get called when the code is run in Excel 2000, but that can be tricky
and does depend on how the code is structured. This would eliminate the
run-time errors, but the compile errors would still occur.

Cleanest way is to develop in Excel 2000.