Ive been doing alot of web scraping projects the last couple of months this is the line i'm usually using the first code below but its really unstable i think With IE Do While .Busy Or .readyState <> READYSTATE_COMPLETE DoEvents Loop End With Many times the macro gets stuck on here, and I have been forced to use this work around: Application.Wait (Now + TimeValue("0:00:12")) You will see that I have adjusted the wait to 12 sec. which is a really long time, but for some sites this is necessarily. is there a better way to make sure the web page is loaded probably? I hope one of you guys with more experience know how to tackle this problem ...

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Do While .Busy Or .readyState <> READYSTATE_COMPLETE

Thread starter fredrerik84
Start date Jul 30, 2017
Tags

.busy .readystate line readystate_complete web

fredrerik84

Active Member

Jul 30, 2017

Ive been doing alot of web scraping projects the last couple of months this is the line i'm usually using the first code below but its really unstable i think

Code:

    With IE
        Do While .Busy Or .readyState <> READYSTATE_COMPLETE
            DoEvents
        Loop
    End With

Many times the macro gets stuck on here, and I have been forced to use this work around:

Code:

    Application.Wait (Now + TimeValue("0:00:12"))

You will see that I have adjusted the wait to 12 sec. which is a really long time, but for some sites this is necessarily. is there a better way to make sure the web page is loaded probably?

I hope one of you guys with more experience know how to tackle this problem ...