Problem with pulling data from a webpage

[imagine1221]

Hello All,

I am writing a VBA module to update data from a webpage on a regular basis and then do some further analysis.

When I was trying to pull the data from a table in the following webpage: http://www.hkex.com.hk/eng/market/sec_tradinfo/stockcode/eisdeqty.htm

like
https://picasaweb.google.com/117501...hkey=Gv1sRgCJW709WjiJWmCA#5599040612601820258

-- removed inline image ---

https://picasaweb.google.com/117501...hkey=Gv1sRgCJW709WjiJWmCA#5599040694157648962

Anyone can help on this? Many thanks

 

[dave3009]

Try the table from http://www.hkex.com.hk/eng/market/sec_tradinfo/stockcode/eisdeqty_pf.htm instead

 

[imagine1221]

Thank you. But, apart from using another page, is there another alternative? as it seems to have the similar situation when trying to grap data from the same website.

 

[dave3009]

No matter how you try to download tables from the main content of that site it's gonna error, Excel's import doesn't seem to recognise the & nbsp ; command. If you suffix each page you wish to download with _pf then you should get your desired result

 

[imagine1221]

Dave, thank you!