Waiting for a web form to reload

[Jrbeene86]

Hey guys,



I am using a macro in vba to fill out a few web forms for a secure web page we use. These web forms tie to a sql server so the load times vary quite a bit. I want the macro to wait until the page has finished updating after I hit update.

I've tried this:

Do
' Wait till the Browser is loaded
Loop Until Obrowser.ReadyState = READYSTATE_COMPLETE

but that only makes it wait until the page is loaded when the browser first starts up or goes to a different page. I notice that the green status bar at the bottom is active and was wondering If I could use that? Maybe loop until that goes away?

There are a few buttons that are disabled and maybe I could loop until they are enabled? could that code be something like this?

Do
' Wait till the Browser is loaded
Loop Until HTMLDoc.All.btnUpdate.Enabled = True


Thanks so much in advance!

[Jrbeene86]

Found it!

'Waits until the form is loaded
Do While Obrowser.Busy: DoEvents: Loop
Do While Obrowser.ReadyState <> 4: DoEvents: Loop