HaimD
asked on
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.Appl ication")
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.
Set OutApp = CreateObject("Outlook.Appl
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.
ASKER
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.Appl ication")
Code breaks on the statement: Set OutApp = CreateObject("Outlook.Appl
How is OutApp defined?
Is Outlook installed on the Win7 machine?
Is Outlook installed on the Win7 machine?
ASKER
Not sure what you mean by "defined," but yes, it is installed and working just fine on the users machine.
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
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
ASKER
If you mean in the VBA code, it's like this:
Dim OutApp As Object
Dim OutApp As Object
Not sure what you mean by "defined"
What I mean is do you have a Dim (or Private or Public) for OutApp?
What I mean is do you have a Dim (or Private or Public) for OutApp?
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Just Excel or all of Office?
all office.
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
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
ASKER
This seems to have worked. Thanks
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.