View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
emri emri is offline
external usenet poster
 
Posts: 1
Default Run Time Automation Error - Help Needed

The easy way i found is to add a second argument to the function CreateObject
but i don't know what consequences it could have on network use:

Set OutApp = CreateObject ("Outlook.Application", "localhost")

hope it could help u


"Mark Campbell" wrote:

I have a macro that has been working great that opens Outlook, attaches an
email and sends it.
However, I have one user that has recently updated their computer and the
macro is now failing.
I get a Run-time error "-2147024770 (8007007e)' Automation Error The
specified module could not be found.
The code stops on the line:
Set OutApp = CreateObject ("Outlook.Application").

Any ideas why this is bombing on this one computer.
They are running Outlook, 2003 SP2 under Windows XP.

I have seen a similiar post here back in April - but no solution. Any helo
greatly appreciated. I know that the antivirus protection was also recently
upgrade to Symantec Antivirus Version 9.

Thanks!

Mark