Extracting specific data from website HTML using VBA

[henrysfh]

hi all,

I would to extract the value in market cap(市值） from this link: NTES-S (9999.HK) 股價、新聞、報價和過往記錄 - Yahoo 財經 by VBA to a worksheet

However I have no idea to do it.

The html code is this

<td class="Ta(end) Fw(600) Lh(14px)" data-test="MARKET_CAP-value" data-reactid="81"><span class="Trsdu(0.3s) " data-reactid="82">484.112B</span></td>

I have tried to use the method of getElementsByClassName by it seems that there is no class name to let me extract it.

Could anyone help me on this? thank you very much.

 

[Marc L]

Hi,​

​

as obviously there is a class name in your html code sample - kid level reading ‼ - so I wanna see what you have tried …​

 

[henrysfh]

I am sorry. I should learn more to ask.