title: Web Scraping value return nothing
body: <p>I tried to web scraping data from website. The HTML shows as:</p>
  <pre><code>   &lt;span class=&quot;company-number&quot;&gt;913100006073563962&lt;/span&gt;
  </code></pre>
  <p>I want to get the &quot;9131...&quot; number and export to excel.
  And after the running, I got nothing in Excel.</p>
  <p>What I wanna achieve is to get a table like: Name Column is the VBA tried to search, and return Number value.. Also the looping process is a little hard..</p>
  <pre><code>    Name1   234
      Name2   243
      Name3   235
      ...     ...
  </code></pre>
  <p>Any help will be highly appreciated!!!</p>
  <pre><code>    Set HT = IE.Document
      Set CorpNos = HT.getElementsByClassName(&quot;company-number&quot;)
  
      i = 1
      For Each CorpNo In CorpNos
        If CorpNo.className = (&quot;company-number&quot;) Then
            Sheet1.Cells(i, 3).Value = CorpNo.innerText
            i = i + 1
          End If
  </code></pre>