You need to wiat for both readystate and busy. It is probably runs at
different speed on different machines and will very depending on the version
of Internet exlporer on you r machines.
from
Do While .Busy: DoEvents: Loop ' runtime error occurs here or on the
next line
Do While .readyState < 4: DoEvents: Loop
to
Do While .readyState < 4 Or .busy = True
DoEvents
Loop
Do While .Busy: DoEvents: Loop ' runtime error occurs here or on the
next line
Do While .readyState < 4: DoEvents: Loop
"musicgold" wrote:
Hi,
Please refer to the following code. This code works fine on my office machine,
but does not work on my laptop and home machine. All three machines have
Excel 2003, SP3, and MS XP.
When I run the code on my laptop, the macro stops at the line : BUSY and the
following error message is displayed.
Runtime error -2147023170, Automation error, The remote procedure call failed.
My guess is that the error has something to do with the way I have defined
the IE object.
I tried changing the Dim IE As New SHDocVw.InternetExplorer declaration to
Dim IE as Object and Dim IE as InternetExplorer, but the error did not go
away.
Code:
Dim IE As New SHDocVw.InternetExplorer '***
Dim URL As String
Dim Ext As String
Dim ocell As Range
Dim file_loc As String
Dim ResultDIV As HTMLDivElement, AllResultsDIV As HTMLDivElement,
OneResultDIV As HTMLDivElement
Dim message As String
Dim htmlDoc As MSHTML.HTMLDocument
Dim htmlInput As MSHTML.HTMLInputElement
Dim htmlColl As MSHTML.IHTMLElementCollection
Dim counter As Integer
Dim DLd As Boolean
file_loc = "C:\newfolder\"
Set IE = CreateObject("InternetExplorer.Application")
With IE
.Visible = 1
.Navigate "http://www.fxstreet.com/forum/showthread.php?t=2910"
Do While .Busy: DoEvents: Loop ' runtime error occurs here or on the
next line
Do While .readyState < 4: DoEvents: Loop
...
Thanks,
MG
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200907/1