Code for runnning macros created in XP in older excel versions

  • Thread starter Thread starter Tom
  • Start date Start date
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
 
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
 
Back
Top