title: How to use getElementsByTagName with <td> with overflow: hidden on VBA?
body: <p>I am using the VBA automation to get some informations of a ticket system in my job. I am trying to get the value into the generated table but only information that doest'go to the column "A" on sheet "Plan1" is <code>&lt;td&gt;</code> which contains the overflow: hidden CSS atribute. I don't know if are them related but coincidently are the only data that don't appears. Someone can help me?</p>
  
  <p>HTML code:</p>
  
  <pre><code>&lt;div id="posicionamentoContent"&gt;
    &lt;table class="grid"&gt;
    &lt;thead&gt;...&lt;/thead&gt;
    &lt;tbody&gt;
       &lt;tr id="937712" class="gridrow"&gt;
           &lt;td width="200px"&gt; Leonardo Peixoto &lt;/td&gt;
           &lt;td width="200px"&gt; 23/12/2015 09:45 &lt;/td&gt;
           &lt;td width="200px"&gt; SIM &lt;/td&gt;
           &lt;td width="200px"&gt; Telhado da loja com pontos de vazamento.&lt;/td&gt;
           &lt;td width="200px" align="center"&gt;&lt;/td&gt;
           &lt;td width="200px" align="center"&gt;&lt;/td&gt;
       &lt;/tr&gt;
  ...
  ...
  ...
  </code></pre>
  
  <p>The complete code: <a href="http://i.stack.imgur.com/4BsFo.png" rel="nofollow">http://i.stack.imgur.com/4BsFo.png</a></p>
  
  <p>I need to get the first 4 <code>&lt;td&gt;</code> text ( Leonardo Peixoto, 23/12/2015 09:45, SIM and Telhado da loja com pontos de vazamento.) but they are only texts which I can't get.</p>
  
  <p>Obs: When I use developers tools (f12) to inspect each element, it shows me perfectly the information I need inside <code>&lt;td&gt;</code>. But when I open "source code" page to checkthe html, the code is like this:</p>
  
  <pre><code>&lt;div id="tabPosicionamento" style="padding: 5px 0 5px 0;"  class="ui-tabs-hide"&gt;
      div id="posicionamentoContent"&gt;&lt;/div&gt;
  &lt;/div&gt;
  </code></pre>
  
  <p>Example VBA:</p>
  
  <pre><code>    Sub extractTablesData1()
       'we define the essential variables
  
       Dim IE As Object, obj As Object
       Dim ticket As String
  
  
       Set IE = CreateObject("InternetExplorer.Application")
  
       ticket= InputBox("Enter the ticket code")
  
      With IE
  
       .Visible = False
       .navigate ("https://www.example.com/details/") &amp; ticket
  
  
       While IE.ReadyState &lt;&gt; 4
       DoEvents
       Wend
  
      ThisWorkbook.Sheets("Plan1").Range("A1:K500").ClearContents
  
      Set data = IE.document.getElementsByClassName("thead")(0).getElementsByTagName("td")
  
              i = 0
              For Each elemCollection In data
              ThisWorkbook.Sheets("Plan1").Range("A" &amp; i + 1) = data(i).innerText
              i = i + 1
  
              Next elemCollection
  
  End With
  
  IE.Quit
  Set IE = Nothing
  
  ....
  
  ....
  
  End Sub
  </code></pre>
  
  <p>This function returns in column <strong>"A"</strong> of sheet <strong>Plan1</strong> only <code>&lt;td class=info3"&gt;&lt;/td&gt;</code> and <code>&lt;td class=info4"&gt;&lt;/td&gt;</code> but I need <code>&lt;td class=info1"&gt;&lt;/td&gt;</code> and <code>&lt;td class=info2 also."&gt;&lt;/td&gt;</code></p>