title: how to get the next td elements from the same tr in HTML, vba
body: <p>i am new in vba. i wants yours opinion in how to get the value from the next td elements by using the condition. lets say, if the elements from the previous td is true then we will take the next td link for download the file.</p>
  
  <p>in the html, this is on one tr and 3 td like this:</p>
  
  <p>TABLE 1. INVENTORIES | Link download.xls | Link download.zip</p>
  
  <hr>
  
  <p>this is my coding:</p>
  
  <pre><code>Dim tr As MSHTML.IHTMLElementCollection, Dim td As MSHTML.IHTMLElementCollection
  
  Dim tdobj As MSHTML.HTMLGenericElement
  Dim trobj As MSHTML.HTMLGenericElement  
  Set tr = htmlDoc.getElementsByTagName("tr")
  For Each trobj In tr
      Set td = trobj.getElementsByTagName("td")
      For Each tdobj In td
          If (Trim(tdobj.innerText) Like "TABLE 1. INVENTORIES*") Then
              "take link download .xls here"
          End If
      Next
  Next
  </code></pre>
  
  <p>it is possible to get? i get the table inventories but i stuck on how to get the "Link download.xls". if there any suggestion, please let me know guys..</p>