Detecting MS Office Version w/code

  • Thread starter Thread starter Bob Bonta
  • Start date Start date
B

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
 
-----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
.
Click to expand...
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
 
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.
 
Back
Top