title: Open website, find specific value and return value to Excel in VBA
body: <p>I would like to use VBA to open a website, look for a certain paragraph in the HTML code of this website (<code>&lt;p class="myClass"&gt;XYZ&lt;/p&gt;</code>) and return this value to Excel, in my example <code>"XYZ"</code>. </p>
  
  <p>The website has only one paragraph (p element) with the above class. </p>
  
  <p>I know that this is possible but don't know where to start here. </p>
  
  <p>My code:</p>
  
  <pre><code>Dim objIE As Object
  
  Set objIE = CreateObject("InternetExplorer.Application")
  
  With objIE
      .Navigate varUrl
      Do While .Busy
            Application.Wait Now + TimeValue("0:00:01")
      Loop
      .Visible = True
  End With
  </code></pre>