Excel VBA - Run-time Error '429': ActiveX component can't create object

I am erroring out on this line in my Excel VBA Code:

Set OutApp = CreateObject("Outlook.Application")

It works fine on all Windows XP machines in our office, except this one that is running on Windows 7.

The Tools>References are identical on both machines, and none are "MISSING."

Please help.
HaimDAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Arno KosterCommented:
what error do you get while running on windows 7 ?

it could be a number of issues. when you provide the error message you get, we will be one step close to solving your problems.
0
HaimDAuthor Commented:
Exactly as that shown above in the subject line of my question:  Run-time Error '429': ActiveX component can't create object

Code breaks on the statement:  Set OutApp = CreateObject("Outlook.Application")
0
Martin LissOlder than dirtCommented:
How is OutApp defined?

Is Outlook installed on the Win7 machine?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

HaimDAuthor Commented:
Not sure what you mean by "defined," but yes, it is installed and working just fine on the users machine.
0
gowflowCommented:
make sure you have refrence  
Microsoft Outlook 11 Object Library is in the refrences (for outloook 2003)
Microsoft Outlook 12 Object Library is in the refrences (for outloook 2007)

Now if it is there what you need to do is untick it press ok then ask for refrences again and then browse thru the list and then tick it again most probably it did not load the dll. It should do it. Sav ethe file re-open and see if it is ok. you may need to reboot your pc also after re-selecting the dll.

Try this and let me know
gowflow
0
HaimDAuthor Commented:
If you mean in the VBA code, it's like this:

Dim OutApp As Object
0
Martin LissOlder than dirtCommented:
Not sure what you mean by "defined"

What I mean is do you have a Dim (or Private or Public) for OutApp?
0
gowflowCommented:
sorry I did not specify how to look for refrence in case you don't know.
1) goto VBA (Visual Basic Editor)
2) on the menu choose tools/refrences
3) there yuou see the list that I talked about etc..
gowflow
0
HaimDAuthor Commented:
It is reference appropriately.

See attached screen shot... Screen shot of references
0
Arno KosterCommented:
sorry, my bad : i missed that.

it looks like some office dll have not been properly registered.
can you try repairing the office installation with the windows installer ?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HaimDAuthor Commented:
Just Excel or all of Office?
0
Arno KosterCommented:
all office.
0
gowflowCommented:
That was my next suggestion, more over
1) make sure all updates for office are installed via Microsoft update
2) after installing any update or repair reboot ur pc and try
gowflow
0
HaimDAuthor Commented:
This seems to have worked.  Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.