HTTP request in VBA

Hi, I have recently read the post here about "how to click javascript alert button when using IE"

Link: http://www.excelforum.com/excel-prog...-using-ie.html

Thanks to the contribution of Kyle123, a solution using http request can successfully capture the data


I understand his script is using get and post to retrieve the response and copy it into the responsetext and look up the corresponding token and table.

I have tried his method, but however I found out that the data retrieved are not complete

In the

For Each rw In doc.getelementsbyTagname("table")

Debug.Print rw.innertext

Next rw

After print out the table in intermediate window, i find out that the table is not complete, only those shareholding with 0% are printed out.

I have tried to print the responsetext before filtering tagname "table" and it also shows that the table is not complete

May I ask whats the problem?

Thank you