version of MS office in VB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ram - 06 Nov 2003 14:51 GMT

In a VB program how can we find out the version of
Microsoft office ? i.e office10, office9 or office8 etc?

Using regread how can we find out the path of excel.exe in
registry
Please let me know
thanks in advance
ram

Reply to this Message

Cindy M -WordMVP- - 12 Nov 2003 15:43 GMT

Hi Ram,

> In a VB program how can we find out the version of
> Microsoft office ? i.e office10, office9 or office8 etc?
>

Generally, I'd say open an Office application that supports
VBA and check the .Version property. It's quite possible that
multiple versions are installed on the same machine...

> Using regread how can we find out the path of excel.exe in
> registry

Go into the Class_Root section of the Registry and search
Excel.Application, get the CLSID for this. Now search the
CSLID and under that the LocalServer/Default information.

(Note: under Excel.Application you can also pick up which
version number - Excel.Application.10, for example - is set
as the "default" on a particular machine)

-- Cindy

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...