Checking Version of Application

[Kent]

I am distributing a spreashdeet with VBA to multiple users with different
versions of Excel. I would like to place code in the open routine that will
check the version and then prompt the user if they are not running Excel 97
with SR-1 or later. Application.version will return 8.0a for 97 SR-1.

I would imagine this is not a new need. Does anyone already have a slick
routine to parse this value and check to see a version later than a
specified verions (8.0a in this case) is loaded on the target machine?

Kent

[Frank Isaacs]

Check out XL97: Overview and History of Excel Patches, at
http://support.microsoft.com/support/kb/articles/Q232/6/52.ASP

Try using application.build instead of application.version. Since it is a
Long value, you can use <, = , and > to test for what you want. You can
cross-reference the build number to the version in the article above.

(You still have to parse the beginning of application.version, of course,
because the builds are not sequentially higher across versions...so you
still need to know if it is 8.0.)
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com

"Kent" <kja...@swri.org> wrote in message
news:tfo382i...@corp.supernews.com...

[Tom Ogilvy]

> (You still have to parse the beginning of application.version, of course,
> because the builds are not sequentially higher across versions...so you
> still need to know if it is 8.0.)

? VAL(application.Version)
8

Regards,
Tom Ogilvy

"Frank Isaacs" <fr...@dolphintechnology.com> wrote in message
news:u4Tonmj2AHA.1352@tkmsftngp07...