View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Mark Campbell Mark Campbell is offline
external usenet poster
 
Posts: 16
Default Run Time Automation Error - Help Needed

Emri,

Thanks for your help - worked perfectly.

I still dont understand why my code stopped working or how this fix worked -
thks again for your help

"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