Get tags in class name.

[b.hill2387]

I would like to be able to put the 4th "td" tag within the class name "togo" into cell values each time the class name "togo" occurs. I think the logic would go something like this:

Sub classtag()
i = 1
For each class name "togo" in HTMLDoc
  Cells(i,1).Value = 4th "td" tag innertext
  i = i + 1
Next
End Sub

I would greatly appreciate any help in translating the above to actual code or suggestions for better or faster approaches.

 

[John_w]

With IE9+ you can loop through the collection returned by HTMLDocument.getElementsByClassName("togo"), otherwise HTMLDocument.getElementsByTagName("TABLE") or maybe ("TR").

 

[b.hill2387]

So something like this? Or would this just pull the 4th "td" tag of the entire HTMLDocument every time?

Sub classtag()
i = 1
For each HTMLDocument.getElementsByClassName("togo") in HTMLDocument
  Cells(i,1).Value = HTMLDocument.getElementsByTagName("td")(3).innertext
  i = i + 1
Next
End Sub