Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I tell if Excel (or OfficeXX) is installed

Status
Not open for further replies.

SBendBuckeye

Programmer
May 22, 2002
2,166
US
I have a VBA code process that I want to generalize for possible future distribution. One of the utility pieces uses Excel in the background so I would need to disable that function if not running Excel and/or Office.

What is the best way to check for that situation? Can I read the registry, if so what keys do I look for? Or would I be OK if I just checked the dll settings to see if the office ones were selected?

Thanks in advance for any help!

Have a great day!
 
For checking installation only - perhaps CreateObject("Excel.Application") will return Nothing or generate error if it is not possible.

combo
 
Duh, that is so simple. Thanks for the idea.

Have a great weekend!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top