Code for runnning macros created in XP in older excel versions

T

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? (So I
don't have to write the code again in excel 2000?

Thanks,
Tom
 
D

Don Guillett

I have a client that sends my wb to many users. Some have xl95. So, I have
xl95,xl97sr2 and xl2002 all on the same computer. I write the program using
xl95.

However, IF you know the difference, you can write to the version.
If version>whatever then do this else do that
 
Top