Re: Program compatability - 2002 vs. 2000

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Mike
I run into to similar problems with developing in XL 2002 and XL 97, the
problems seem to lie in two areas.....
1. Commands that either are non-existent or have extended features.
2. Sublte changes in the way VBA deals with variables formats etc.

The first is the easiest to spot but most difficult to fix, usually VBA
throws an error and you then need to explore differences, unfortunately the
fix often means a code section rewrite.

The second is simplest to fix but the most annoying as it is not always
obvious what the problem is. Recently I had a procedure that worked fine in
XL2002 - it tested for a numerical value on a work***, in XL97 the same
work*** thru an errror - type mismatch. The work*** value was in fact a
string (numerical characters!). The fix in XL97 worked fine in XL2002.

I guess the best approach (if possible) is to work in the oldest version and
test in the later version(s). Froward compatability is more likely - but
not always guaranteed!


--
Cheers
Nigel



"Mike D." <MikeD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:46EAC60E-CF24-4982-8118-D635F28A244E@xxxxxxxxxxxxxxxx
> Hi. I am writing macros in 2002 and would like for people using 2000 to
be
> able to us the macros. I am running into problems ... Is there a
> compatability issue between the two? Is there a way around this other
than
> having the others upgrade?
>
> Thanks,
> Mike.


.

Quantcast