Detecting MS Office Version w/code

[Bob Bonta]

I need to know if there is any way I can detect the versin
of MS Office installed on a given machine - in code while
an Access application is booting.

Any thoughts are more than appreciated.

BB

 

[Guest]

-----Original Message-----
I need to know if there is any way I can detect the versin
of MS Office installed on a given machine - in code while
an Access application is booting.

Any thoughts are more than appreciated.

BB
.

With the MS office reference turned on. we just use:

Select Case (Application.References("office").Major)

to grab the version number. We need to XP there is also
a .version

hope that helps.
George

 

[John Nurick]

Hi Bob,

It's easy to get the version of Access that is running the code
(Application.Version). As for the version of Office, that's a whole
other kettle of fish, because a computer can have some or all components
of several version installed at the same time.

 

[MikeC]

Bob,

The code at the below link provides a way to detect both
the office executable versions and which patches are
installed.

http://www.mvps.org/access/api/api0065.htm