Web Query import data before webpage fully loads

Hi,

Tried to use VBA to do a web query, but it pulls in the data before the page is fully loaded.
http://vip.stock.finance.sina.com.cn/mkt/#lwg_qh
The numbers in the table are not loaded when I import the page

Is there any way to delay the loading by 5 seconds before importing the page?

Thanks

Hi,

use Wait method …

But I tkink it's a bad code, post it using code tags as per forum rules …

The table is built in JavaScript so you need to parse the Json:

Please Login or Register  to view this content.

Updated...