P
pfsardella
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.marketwatch.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
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.marketwatch.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