ActiveX Component Can't Create Object: EXCEL6 Error

[Schwimms]

Hi All,

I am having the "Run Time Error 429: ActiveX Componenet Can't Create Object" occur at this line of code:

Set OutApp = CreateObject("Outlook.Application")

This use to be a working auto emailer macro till I was moved to Windows 7. Apparently what I noticed is that I can get it to work if I close down the class EXCEL6 that is running in my background processes.

I need to be able to have this macro run without manual intervention. Could someone assist me with some code that can either close down the EXCEL6 process that is running in the background or help me figure out another way to keep this macro running?

 

[Norie]

Do you have Outlook installed?

 

[Schwimms]

Yes. The problem exist with the EXCEL6 instance being open in the background processes, as to why that causes my problem, I don't know.

 

[Norie]

If that's causing the problem why is the error happening when you try and create a new instance of Outlook?

Also, what exactly do you mean by EXCEL6?

 

[Schwimms]

Not sure, but as soon as I close down the Excel process running in the background it will run that macro without getting the active X error.

When I say EXCEL6 I am referring to finding the open excels class name which I was able to figure out using the code presented here: http://www.mrexcel.com/forum/excel-questions/279967-api-function-findwindowex.html