Excel 97
Windows 98SE
Internet Explorer 5.5

Getting the following error message (crashes Excel) when trying to run
a bunch of routines that automate Internet Explorer other than opening
a new browser :
EXCEL caused an invalid page fault in module RPCRT4.DLL at
0167:7fbd0894.

Routines that fail basically either :

- Refresh a browser's hyperlink given certain links
- Cycle through open browsers to refresh one with a given handle
- Open a browser and login

-------------------------------------------------------

Some example code that stopped working (no problems before). I left
out declarations :

-------------------------------------------------------

Set oSW = New ShellWindows
For Each oIE In oSW Crashes here
If InStr(1, oIE.LocationURL, "bigcharts.marke****ch.com") < 0
Then
If InStr(1, oIE.LocationURL, "nasdaq") < 0 Then oIE.Refresh
End If
Next oIE

-------------------------------------------------------

Set ie2 = CreateObject("InternetExplorer.Application")
With ie2
.Navigate ("https://wwws.ameritrade.com/cgi-bin/apps/Main")
.Visible = True
Do While ie2.ReadyState < READYSTATE_COMPLETE
Sleep 1000
Loop
Set oDoc = ie2.Document.all.Item("USERID") Fails here
If Not oDoc Is Nothing Then oDoc.Value = "myloginID"
Set oDoc = Nothing
Set oDoc = ie2.Document.all.Item("PASSWORD")
If Not oDoc Is Nothing Then oDoc.Value = "mypassword"
Set oDoc = Nothing
Set oDoc = ie2.Document.all.Item("loginBtn")
If Not oDoc Is Nothing Then oDoc.Click
End With

-------------------------------------------------------

The only thing I did just prior to having the problem : I had
downloaded some software to play DVDs the prior day. I believe that
the installation changed (overwrote) some files without asking for
confirmation. I uninstalled the software. Next morning I started to
have problems.

* Tried repairing IE6 through Control Panel. Control Panel
Add/Remove Programs IE6 Tools Repair.
* Scanned for viruses with AVG. Ran Spybot and Ad-Aware.
* I replaced RPCRT4.DLL from .cab files.
* I replaced Schannel.dll from .cab files.
http://support.microsoft.com/kb/315209
* No missing references for any of the files (in the VBE)

Any ideas on how to deal with this issue would be greatly appreciated.
I'm at a loss.

Thanx,
Paul

On Sat, 11 Aug 2007 00:46:53 -0700, am wrote:

For posterity :

I upgraded to Internet Explorer 6.0 and still experienced the same
problem.

Examining the call stack through the Visual C++ debugger showed that
Oleaut32.dll was calling RPCRT4.DLL. The version of Oleaut32.dll
installed on my hard drive was for Windows NT. I obtained the correct
version of Oleaut32.dll and installed that. Problem solved.

Paul