halt program execution while web page loads

hmclark · #1 (**permalink**) January 25th, 2013, 02:00 AM

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

hmclark · #2 (**permalink**) January 25th, 2013, 07:17 AM

hi , after searcing through other posts here, I found this solution

Code:

        With ie
            Do Until (.ReadyState = 4 And Not .Busy): DoEvents: Loop
        End With

works very well in my case.

regards

Need to download code?

Navigation