title: How to extract data from website with VBA Excel?
body: <p>I need to extract the information from <a href="https://www.te.com/usa-en/search.html?q=917695-1&amp;type=products" rel="nofollow noreferrer">TE website</a>. The data include the fields and the table shown in the picture.</p>
  
  <p><img src="https://i.stack.imgur.com/GFxPb.jpg" alt="Website"></p>
  
  <p>I read some example code to extract the data from website using VBA in Excel, like this one for example <a href="https://stackoverflow.com/questions/12989687/fetch-website-data-into-excel-using-vba-excel-macro">Stackoverflow's Example</a>. I understand some but I cannot find how to adapt into my problem.</p>
  
  <p>There are some comments I found that I will need to know some HTML to do it - but I have no clue how.</p>
  
  <p>I tried to look into the code of the page then I found the information hidden but still hard to have some thoughts about extracting these fields.</p>
  
  <pre class="lang-html prettyprint-override"><code>&lt;span class="te-search-gallery-family"&gt;2.5mm Signal Double Lock Connector&lt;/span&gt;
  &lt;span class="te-search-gallery-desc"&gt;2.5 SIGNAL D/LOCK PLUG HSG 11P&lt;/span&gt;
  </code></pre>
  
  <p>and</p>
  
  <pre class="lang-html prettyprint-override"><code>  &lt;th class="first-cell"&gt; Product Type&lt;/th&gt;
    &lt;th&gt; Connector Type&lt;/th&gt;                                          
    &lt;th&gt; Connector Style&lt;/th&gt;                                         
    &lt;th&gt; Product Line&lt;/th&gt;                                            
    &lt;th&gt; Centerline&lt;/th&gt;                                          
    &lt;th&gt; Application Use&lt;/th&gt;                                         
    &lt;th&gt; Applies To&lt;/th&gt;                                          
    &lt;th&gt; Wire/Cable Type&lt;/th&gt;                                         
    &lt;th&gt; Contact Type&lt;/th&gt;                                            
    &lt;th class="last-cell"&gt; Number of Positions&lt;/th&gt;
  &lt;/tr&gt;
  &lt;/thead&gt;
  &lt;tbody&gt;
      &lt;tr&gt;
        &lt;td class="first-cell"&gt; Connector&lt;/td&gt;
        &lt;td&gt; Housing&lt;/td&gt;                                         
        &lt;td&gt; Plug&lt;/td&gt;                                            
        &lt;td&gt; 2.5mm Signal Double Lock&lt;/td&gt;                                            
        &lt;td&gt; 2.50 mm [0.098 in]&lt;/td&gt;                                          
        &lt;td&gt; Wire-to-Wire&lt;/td&gt;                                            
        &lt;td&gt; Wire/Cable&lt;/td&gt;                                          
        &lt;td&gt; Discrete Wire&lt;/td&gt;                                           
        &lt;td&gt; Socket&lt;/td&gt;                                          
        &lt;td class="last-cell"&gt; 11&lt;/td&gt;
      &lt;/tr&gt;
  </code></pre>