title: Get data points in web page via vba
body: <p>I need to get specific values on this webpage. How do I get just those values into Excel?</p>
  
  <p><a href="http://www.securities-administrators.ca/nrs/nrsIndvSearchResults.aspx?mode=QS&amp;type=I&amp;indv=david+hill" rel="nofollow noreferrer">http://www.securities-administrators.ca/nrs/nrsIndvSearchResults.aspx?mode=QS&amp;type=I&amp;indv=david+hill</a></p>
  
  <p>Below is the fragment of HTML content for the results, I would need the value "BOOTH, David (Arthur)" for example to be imported into Excel.</p>
  
  <pre><code>&lt;div&gt;
      &lt;table border="1" cellspacing="0" class="gridview_style" id="ctl00_bodyContent_gvIndividuals" rules="all" style="width:100%;border-collapse:collapse;"&gt;
          &lt;tr&gt;
              &lt;th scope="col" style="width:50%;"&gt;&lt;span id="ctl00_bodyContent_gvIndividuals_ctl01_lbl_ind"&gt;Name&lt;/span&gt;&lt;/th&gt;
              &lt;th scope="col" style="width:50%;"&gt;Firm(s)&lt;/th&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
              &lt;td class="articleText"&gt;
                  &lt;a href="javascript:__doPostBack(&amp;#39;ctl00$bodyContent$gvIndividuals$ctl02$lbtnIndDetail&amp;#39;,&amp;#39;&amp;#39;)" id="ctl00_bodyContent_gvIndividuals_ctl02_lbtnIndDetail"&gt;BOOTH, David (Arthur)&lt;/a&gt;
              &lt;/td&gt;
              &lt;td class="articleText"&gt;&lt;span id="ctl00_bodyContent_gvIndividuals_ctl02_lblFirmName"&gt;SCOTIA CAPITAL INC. / SCOTIA CAPITAUX INC.&lt;/span&gt;&lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
              &lt;td class="articleText"&gt;
                  &lt;a href="javascript:__doPostBack(&amp;#39;ctl00$bodyContent$gvIndividuals$ctl03$lbtnIndDetail&amp;#39;,&amp;#39;&amp;#39;)" id="ctl00_bodyContent_gvIndividuals_ctl03_lbtnIndDetail"&gt;HILL, David (Adam)&lt;/a&gt;
              &lt;/td&gt;
              &lt;td class="articleText"&gt;&lt;span id="ctl00_bodyContent_gvIndividuals_ctl03_lblFirmName"&gt;RBC DIRECT INVESTING INC./RBC PLACEMENTS EN DIRECT INC.&lt;/span&gt;&lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
              &lt;td class="articleText"&gt;
                  &lt;a href="javascript:__doPostBack(&amp;#39;ctl00$bodyContent$gvIndividuals$ctl04$lbtnIndDetail&amp;#39;,&amp;#39;&amp;#39;)" id="ctl00_bodyContent_gvIndividuals_ctl04_lbtnIndDetail"&gt;HILL, David (Lowell)&lt;/a&gt;
              &lt;/td&gt;
              &lt;td class="articleText"&gt;&lt;span id="ctl00_bodyContent_gvIndividuals_ctl04_lblFirmName"&gt;STATE FARM INVESTOR SERVICES (CANADA) CO.&lt;/span&gt;&lt;/td&gt;
          &lt;/tr&gt;
      &lt;/table&gt;
  &lt;/div&gt;                                    
  </code></pre>