Scraping a specific <td> tag that is nested inside a <tr> tag with VBA

the html i am trying to scrape:

HTML Code: 

I am trying to scrape data from a website that has html structured like this within VBA. the value of interest that I want is "750" however it can sometimes be 0, 1,000,000, or any number in between so a set number of characters to extract wont work.

can anyone give some insight on the best way to scrape this? this is my code that will import all of the text as is, but the logic to post process and trim the data of interest is proving very difficult so i am looking for a nice clean way to scrape the 750 slot (the second <td> tag that is nested in this <tr>) as is.

Please Login or Register  to view this content.

One solution is to clean the <> sets
1. find a "td><td>"
2. delete up to the ">"
locate the next "<"
3. the seeked number is in between


<tr><td>Tanks:<br /><i>Lost:<br />Destroyed:</i></td><td>750<br /><i>6<br />18</i></td></tr>

Try

Please Login or Register  to view this content.