excel - Extracting the inner text from span using vba

Question

I am trying to scrap some data from a webpage into Excel using vba.

The html code is

<span id="lastPrice">300.21</span>

I want the number 300.21

I tried this but didn't work (returned nothing in st)

Dim st As String

st = htmldoc.getElementById("lastPrice").getElementsByTagName("span")(5).innerText

How can I get the desired output ?

Answer 1

Try this:

Dim element as Object
Set element = htmldoc.getElementById("lastPrice")

Dim price as String
If Not element Is Nothing Then price = element.innerText