Data being copied from website while page still loading

[Skybeau]

I use a URL to get information from a webpage, however the code below is copying the webpage before it's fully loaded. I've tried various versions of the Readystate loop, but sometuimes the page is slow to load, however it's still copying the webpage data. I'm looking for help to delay the copy of the webpage until all the data is available.

Full sub below:

[excelliot]

Hi

Replace this code :

Please Login or Register  to view this content.

with this code:

Please Login or Register  to view this content.

[Skybeau]

Hi

Replace this code :

Please Login or Register  to view this content.

with this code:

Please Login or Register  to view this content.

The first URL loads quicker than the second one.

https://fasttrack.grv.org.au/Dog/Form/1001120075

https://fasttrack.grv.org.au/Dog/Form/1006270002




I've tried that, doesn't work. There's a table that gets loaded, and a query, I'm assuming that has to load as well. The wheel doesn't stop spinning until the query is loaded. There's no set times per URL, so sometimes it copies the info I want, and then sometimes it doesn't.

[excelliot]

use this line before code which is copying data

Please Login or Register  to view this content.

[excelliot]

Also you can add this line instead wait before lines which copying data:

Please Login or Register  to view this content.

This is working..

[Skybeau]

Thanks for your help, but am getting the following error message

Method 'Document'of Object ÍWebBrowser2' failed.

Do I need to reference anything?