View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Code for runnning macros created in XP in older excel versions

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 versionwhatever then do this else do that

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