How to use getElementsByTagName with <td> with overflow: hidden on VBA?
<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>