Need help with documentcomplete statement

[bg18461]

Hi,

I am trying to find a more reliable event then do until readystate =4 and do while busy to grab a table from an intranet site once the page has fully loaded. I have noticed in some instances, especially when working remotely with a slower connection, my code executes before a table is fully loaded some i miss some rows of data intermittently.

From my reading it looks like the documentcomplete event may be more reliable. This is not a multi frame webpage so I believe this event should be a better option, but I need a little help in implementing it in my code shown below. The issue really happens after the "ctl00_MainContentRegion_btnRunReport" button is clicked. This is when the table is loaded then i have code afterwards that reads the table into excel. Any help?

Please Login or Register  to view this content.

[LJMetzger]

The following seems to work better for me than just looking for ReadyState = 4. I'm no expert, it was just trial and error until I got a repeatable stable result.

Please Login or Register  to view this content.

Lewis

[Norie]

I tend to add something like this to wait for both IE and the document being loaded in IE to be ready before the code continues.

Please Login or Register  to view this content.

[bg18461]

Thank you LJ and Norie. I have used both and they seem successful. I will continue to test these options out over the next few days to see which to settle on. Thanks again!