title: How to web-scrape with Excel VBA?
body: <p>I need to extract information from a website to Excel. I tried different codes.</p>
  <p>I receive</p>
  <blockquote>
  <p>Run time error 91</p>
  </blockquote>
  <pre class="lang-vb prettyprint-override"><code>Sub oslobors()
      Dim IE As Object
      Dim nettside As String
  
      nettside = &quot;www.oslobors.no&quot;
  
      Set IE = CreateObject(&quot;InternetExplorer.Application&quot;)
    
      nettside.Visible = True
      IE.navigate (&quot;www.oslobors.no&quot;)
  
  
      Do While IE.busy
          DoEvents
      Loop
  
      Range(&quot;A2&quot;).Value = nettside
      Range(&quot;B2&quot;).Value = getElementsByTagName(&quot;Handelssymbol&quot;).InnerText
  
      IE.Quit
      Set .IE = Nothing
  End Sub
  </code></pre>