How To Get Html Element With Vba In Excel?

March 20, 2024 Post a Comment

I have an HTML in my Excel:

Copy

2) Now you can use:

Dim row AsObjectSet row = Doc.getElementsByTagName("row_1");

3) Now you can retrieve get your values like this:

row.getElementsByTagName("td")(1).getElementsByTagsName("font")(1).innerText

Html5 Tips