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 ?

Do you have multiple elements that use "lastPrice" as their ID? — user6432984
– user6432984, Commented Jul 6, 2017 at 18:17
No I don't have.Here's the link nseindia.com/live_market/dynaContent/live_watch/get_quote/… — user3126632
– user3126632, Commented Jul 6, 2017 at 18:34
document.getElementById("lastPrice").innerText returns the correct number using the Chrome's Console. Could you post more code or a download link? — user6432984
– user6432984, Commented Jul 6, 2017 at 18:49
No worries. Please accept Kostas K. answer and close the question. — user6432984
– user6432984, Commented Jul 6, 2017 at 18:53
@user3126632 your question contains exactly nothing that writes to any cell, and isn't about writing to a cell. If you have another question, ask another question. Give Kostas' answer the checkmark it deserves. — Mathieu Guindon
– Mathieu Guindon, Commented Jul 6, 2017 at 19:25

Kostas K. · Accepted Answer · 2017-07-06 18:02:58Z

6

Try this:

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

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

answered Jul 6, 2017 at 18:02

Kostas K.

8,5282 gold badges26 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Where is this coming from? Is there an element showing 2200.00% anywhere on the page?

No I didn't find anything on the page