How can I determine if Office is Installed

[michaelbr55]

I have added the command bars collection to a project, but this is only available if office is installed. How can I determine if a user of the project has office of not, so I can let then know it's not available to non-office users, without crashing the application.

Mike

 

[MeGustaXL]

Hi Mike,

Am I missing something here? Surely if your application uses VBA it follows that it's an Office application, from which it also follows that the User has Office installed?





Chris

Varium et mutabile semper Excel

 

[michaelbr55]

Yes! you are missing something, It is possible to install office applications without Office, ie you can install MS Word or Excel or Access all by themselves, and not have Office installed.

Mike

 

[Bowers74]

So Mike,

I guess what you are REALLY asking is . . .

Is there any way of determining if a user has Word, Excel, Access, PowerPoint OR FrontPage installed?

or are you asking . . .

Is there any way of determining if a user has Word, Excel, Access, PowerPoint AND FrontPage installed?

I guess, the easy answer is YES either way, since VBA macros are application specific and it wouldn't matter if the user has Access installed and not Excel, but were trying to open an Excel file. Or would it?

Please clarify . . .

What application is necessary for your program/macro to run?



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[MeGustaXL]

Jeepers, I never knew that!!

Thanks Mike; once again I've spent a day staring at T-T and come away a better educated person.




Chris

Varium et mutabile semper Excel

 

[michaelbr55]

Hi Mike,
My application is a MS Word macro, it only requires Word to run, but to add the commandbars collection it requires the MS Office 9.0 Object Library which is located on my machine in "C:\Program Files\Microsoft Office\Office\MSO9.dll"

If a user only has MS Word installed, I imagine that this file wouldn't exist? Right or Wrong?

So if I add command bars and this doesn't exist, my application will crash when I call these objects!

Mike