Hi everyone I am haveing a problem with a visual basic 6 program.
the program sends a search string to a web page then takes the result and updates an excel spreadsheet. problem is some of the websites are very SLOW loading and by the time the page loads, my
vb program has moved on.
I have tried the following 2 option but niether is halting execution long enough
Code:
With ie
While ie.Busy
DoEvents
Wend
While Not .ReadyState = 4
Sleep 2000 'wait 2 sec before trying again
Wend
End With
I have tried increasing the sleep time, with same result.
Any help would be greatly appreciated