Run-time error '-2147024770 (8007007e)'

[DennyC]

I have a template that loads my outlook calendar into Word, but just recently, I'm getting a VBS error upon loading and the macro stops. Along with the run time error, it says "Automation error. The specified module could not be found. Help please. I'm using office 2003 and XP, SP2. My wife has the same system and the file runs OK on her machine, so I've done something different, but can't seem to figure out what.

Thanks in advance.

DC

 

[Russ]

DC,
As much information as you can, please. Sort of like: "my car stopped with
the 'check engine light' on, what spark plug do I change to get it running
again? ;-)
Did it work before with your setup? (because you said "just recently")
What have you done since it worked last, if it did?
Does it show you which line in the program it can't run (what module)?
Is this VBS or VBA code? This forum is for VBA code.
Show all code, if you can.

 

[Russ]

DC,
Using a google search, I found this:

DC,
As much information as you can, please. Sort of like: "my car stopped with
the 'check engine light' on, what spark plug do I change to get it running
again? ;-)
Did it work before with your setup? (because you said "just recently")
What have you done since it worked last, if it did?
Does it show you which line in the program it can't run (what module)?
Is this VBS or VBA code? This forum is for VBA code.
Show all code, if you can.

 

[DennyC]

Russ,

I tried the link and it did not correct the problem. When I get the error,
I can run Debug and I get the following:

Public Sub Autonew()
Application.StatusBar = "Initializing. Please Wait..."
MY.Show
End Sub
Public Sub Restart()
DoEvents
MY.Show
End Sub

Line 3 is highlighted, but I'm not sure why. I can see this exact code on
my other machine and it runs it with no problem.

DC

 

[Russ]

Denny,
Which application is this code in? I'm not familiar with capturing the
restart? command with Public Sub Restart() on a form in Word.

Put a breakpoint, just before the line that gives the error and when it
stops there after starting, try to single step through the code with the F8
key (Word VBA). Your third line is the 'MY.Show' line, correct? If that form
still exists, it should single step through the initialization code of that
form to where the real error line is.
In Word there is usually a Projects window open in the VBA Editor and it has
a Folder for some projects for forms. Is the "My" form in one of those
folders?

 

[DennyC]

Russ,

I fixed the problem by doing a system restore. I also found out that by
removing, or at least attempting to remove Norton System Security, that is
what hosed up the works. I am evidently stuck with Norton, like it or not.
My subsciption expired and I decided to use something else. Not a good
idea. When Norton gets its hooks in your system, it don't want to let go.
The uninstall bombed and I can't a clean reinstall either. What a deal.
Anyway, thanks for your help.

Denny

 

[Russ]

Denny,
Glad, you figured it out.
I listen to a lot of internet computer talk show streams.
They usually advise dropping a bloated Norton and using AVG.
From what I heard, here are some links to get you on the right path.
<http://www.helpmerick.com/links_resources.htm>
<http://www.google.com/search?&q=remove+norton>
<http://www.pcdecrapifier.com/>