Excel Programming VBA

Question

0.00/5 (No votes)

See more:

Hi Coders,

I want to add a check for Microsoft Office 2003 or 2007 in my code.

If I want to import the Excel 2007 dll's and not 2003's how can I check using a macro if 2007 is installed or not?

If it is then 2007 dll's should be included and if not then 2003 dll's should be included.

For Example:

//if 2007 
#import "C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL"
// else if 2000
#import "C:\Program Files\Microsoft Office\Office\MSO9.DLL"

please help .

Thanks in advance

Posted 18-Aug-10 20:42pm

deepakkumargautam

Updated 18-Aug-10 23:23pm

Emilio Garavaglia

v3

Add a Solution

Comments

Dalek Dave 19-Aug-10 3:27am

Minor Edit for Readability.

Emilio Garavaglia 19-Aug-10 5:23am

retagged as C++/CLI

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nuri Ismail · Answer 1 · 2010-08-18T22:04:00

Solution 1

With a quick search in CodeProject I found this[^] useful article. :)

Posted 18-Aug-10 22:04pm

Nuri Ismail

Comments

Dalek Dave 19-Aug-10 4:06am

Good Call.

Eugen Podsypalnikov 19-Aug-10 4:45am

...any idea to switch the #import directive ? :)

Nuri Ismail 19-Aug-10 5:24am

Shortly I have no idea.
Since #import directive creates header files I don't think that this directive can be used dynamically (but I'm not sure, it's only an opinion).
I decided to answer the question about getting the office version.
I'm not familiar with power and flexibility characteristics of #import, because I've only used C/C++ automation (CoCreateInstance(), IDispatch, IUnknown etc) in the past. :)