How To Get HTML Element With VBA In Excel?

February 07, 2023 Post a Comment

I have an HTML in my Excel:

Copy

2) Now you can use:

Dim row As Object
Set row = Doc.getElementsByTagName("row_1");

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

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

Html5 Playground