checking Excel version number
Hi all,
I use this:
xlVer = CLng(Left(Application.Version, 2))
Do you think it's reliable for any version, system,
language?
Regards,
Peter
-----Original Message-----
"Alan Beban" skrev i melding
...
Hi Harald,
I ran the following in xl2000 (Version 9.0)
(snip)
and it printed this
1 9.0 newer than 8
3 9.0 newer than "8"
5 9 newer than 8
What's going on?
Beats me Alan. This is the result from my XL2000 on
norwegian WinXP /
regional settings:
1 13 Type mismatch
1 9.0 newer than 8
2 13 Type mismatch
2 9.0 older than 8
3 9.0 newer than "8"
5 9 newer than 8
I don't have anything but 9 and 11 on this machine, so I
can't test further
until tonight.
Best wishes harald
.
|