Simple Help - Wait

[smartguy]

Hello all,

Good day.

I am using VBA Macro to extract data from Website... Everything working fine.

Cells(argnums, 2) = objIE.Document.body.innerText

I am running for 10 Values. BUt 1 get only 5 results.

I need macro to wait untill website data paste in excel.

Please help.

Regards,

 

[pbornemeier]

Use Do While ie.busy Or Not ie.readystate = READYSTATE_COMPLETE as shown in this post:
http://www.mrexcel.com/forum/showthread.php?311943