A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Run-time error Automation Error



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old April 21st 06, 07:40 PM posted to microsoft.public.outlook.program_vba
David
external usenet poster
 
Posts: 196
Default Run-time error Automation Error

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.

Thanks!

David
Ads
  #2  
Old April 24th 06, 02:43 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Run-time error Automation Error

Are they running a script stopper, such as the ones from Norton or McAfee?
Those can stop your code from running and many of them don't like
CreateObject. If Norton you're out of luck. It can't be told to trust an
application. McAfee lets you trust code but it would have to be in an EXE or
DLL I believe.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"David" wrote in message
...
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.

Thanks!

David


  #3  
Old April 24th 06, 11:46 PM posted to microsoft.public.outlook.program_vba
Wes
external usenet poster
 
Posts: 18
Default Run-time error Automation Error

I had the same problem but Sue Mosher has a solution for the Norton case -
see her post in the "Problem automating Outlook" thread.

Wes

"Ken Slovak - [MVP - Outlook]" wrote:

Are they running a script stopper, such as the ones from Norton or McAfee?
Those can stop your code from running and many of them don't like
CreateObject. If Norton you're out of luck. It can't be told to trust an
application. McAfee lets you trust code but it would have to be in an EXE or
DLL I believe.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"David" wrote in message
...
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.

Thanks!

David



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automation Error Lightknight Outlook and VBA 3 April 4th 06 02:46 PM
allow me to run macro time initiated hirosh Outlook and VBA 1 April 1st 06 06:40 AM
error (0x80040115) sending and receiving email messages first time Houmom Outlook - General Queries 3 February 6th 06 05:45 AM
run time error nuti Outlook and VBA 0 January 17th 06 01:13 PM
How do I fix time-out error on OE6? C & M Blankenship Outlook Express 3 January 10th 06 06:21 AM


All times are GMT +1. The time now is 05:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2024 Outlook Banter.
The comments are property of their posters.