title: How to get data from class name inside a id name in excel VBA?
body: <p>How can I get data from the classes <code>date</code> and <code>number</code> (all 3) data?</p>
  
  <p><a href="https://i.stack.imgur.com/Cf7Fy.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Cf7Fy.png" alt="HTML code"></a></p>
  
  <pre class="lang-vb prettyprint-override"><code>Sub Fii_dii()
      Set IE = CreateObject("InternetExplorer.Application")
      IE.Visible = True
      IE.Navigate "https://www.nseindia.com/products/content/equities/equities/fii_dii_market_today.htm"
  
      While IE.readyState &lt;&gt; 4
          DoEvents
      Wend
  
      'Copy data
      MsgBox IE.Document.all.Item("fiiTable").innerText
  End Sub
  </code></pre>