Microsoft Office - How to check Apps

[Seán]

Hi All,

just figured out how to check Microsoft Office applications, if they are installed and the version...

I also refer you to read http://support.microsoft.com/kb/240794 where I picked this up from.

Code: Select all

DEFINE REGION: Check Application Requirements
    Check Registry Key HKLM\SOFTWARE\Classes\Excel.Application\CurVer\ into OfficeCurVer
END REGION


This will give you "if the product is installed" (otherwise the registry entry shouldn't be there NO$KEY) and the version as follows:

OFFICECURVER = Excel.Application.15

This works for both Office 2010 and Office 2013 that I've tested so far (Windows 7 x86 and x64)

The trick I've worked out is to use the Application Class (as stored in the registry) which is version agnostic rather than try to determine the version of the application by reading the office keys direct.

The application Classes are:

Code: Select all

Microsoft Access       Access.Application
Microsoft Excel        Excel.Application
Microsoft OneNote      OneNote.Application
Microsoft Outlook      Outlook.Application
Microsoft PowerPoint   Powerpoint.Application
Microsoft Visio        Visio.Application
Microsoft Word         Word.Application


Microsoft Project (2013) does not use Application Classes as above so use the following keys registry entry:

Code: Select all

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Project\shell\open\command

which will return something akin to:

C:\PROGRA~1\MICROS~4\Office15\PROTOC~1.EXE "%1"

Hope this helps and if anyone wants to add updates to this please do...

Best regards
Seán

[FrancescoT]

... Thanks for sharing it!

Regards