Determine if an Office application is installed

[Guest]

Does anyone know of a way within Access VBA to determine if an Office
application is installed on a users workstation. I would like to enable or
disable certain functions within my application based on which office
applications are installed and also it would be helpful to know which version
of the office application is installed.
Thanks

 

[Guest]

Yes this can be done. I have previously found code for different app by
googling each one.

for instance to check for MS Project
http://groups.google.ca/group/micro...read/thread/d9beacf69a581c6d/6d4d0e4f00d7a319
http://groups.google.ca/group/micro...read/thread/5c9b7d559b32a7b1/4bc4be1afcb6c126

Also, you could check reg keys if you know what you are looking for.

 

[Douglas J. Steele]

You can try to instantiate an object, and check if there's an error.

For example,

Function ExcelInstalled() As Boolean
On Error Resume Next

Dim objExcel As Object

Set objExcel = CreateObject("Excel.Application")
ExcelInstalled = (Err.Number <> 429)
Set objExcel = Nothing

End Function