I need to get some data from html, but my code does not work for the first set of data the Tag = a Id = u_0_p and for the second it is via class Tag = div Class = _50f4 I was doing this but it does not work dd = doc.getElementsByTagName("a") .getElementById("u_0_p") '(0) .innerText dd1 = doc.getElementsByTagName("Div") .getElementByClassName("_50f4")(3).innerText I keep getting an error message "Object does not support this property or method"

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Get html via vba code error

Thread starter Sharid
Start date May 25, 2019
Tags

class error html tag work

Sharid

Well-known Member

May 25, 2019

I need to get some data from html, but my code does not work

for the first set of data the

Tag = a
Id = u_0_p

and for the second it is via class

Tag = div
Class = _50f4

I was doing this but it does not work

Code:

dd = doc.getElementsByTagName("a") .getElementById("u_0_p") '(0) .innerText
dd1 = doc.getElementsByTagName("Div") .getElementByClassName("_50f4")(3).innerText

I keep getting an error message "Object does not support this property or method"