How to extract web data into a temporary file that would be used as input variables

Hi all,

I would like to download all stocks' ticker from below web page in a temporary file that would be used for other processes later, but when I view the HTML code (the red below is examples of 2 stocks, ticker 00001 and 00002), I don't know how to tell vba to distinguish each stock as they are seemingly sharing the same tagname and class. Another question is what the code is when create a temp file to store the list of stocks ticker. Please advise me how to solve this problem. Thanks
http://www.hkexnews.hk/sdw/search/st...gDate=20141011
<TR valign="Top" class=TableContentStyle2><TD align=Center>00001</TD><TD nowarp=nowarp align=left><a href=# onClick="ssc('00001','CHEUNG KONG (HOLDINGS) LIMITED');"><span class="arial11grey">CHEUNG KONG (HOLDINGS) LIMITED</span> </a></TD></TR>
<TR valign="Top" class=TableContentStyle1><TD align=Center>00002</TD><TD nowarp=nowarp align=left><a href=# onClick="ssc('00002','CLP HOLDINGS LIMITED');"><span class="arial11grey">CLP HOLDINGS LIMITED</span> </a></TD></TR>

Could anyone give me a hand?

Hi abousetta, both stock code and stock name

Originally Posted by abousetta

what info are you trying to get from this?

Thanks abousetta

Originally Posted by abousetta

Put this in a standard module:

Please Login or Register  to view this content.

You need http://www. at the beginning of the URL.

abousetta

Hi lubbamkt !

You already had two others methods in your previous thread ! …