title: VBA Script pull data from website
body: <p>I want to pull the data from <a href="http://www.buyshedsdirect.co.uk/" rel="nofollow">http://www.buyshedsdirect.co.uk/</a> to get the most recent prices of specific items. </p>
  
  <p>I have an excel spreadsheet with the following:</p>
  
  <pre><code>|A | B
  1 |Item |Price
  2 |bfd/garden-structures/arches/premier-arches-pergola
  </code></pre>
  
  <p>and the VBA script:</p>
  
  <pre><code>Dim ie As New InternetExplorer
  Dim item As String
  item = Sheet1.Range("A2").Value
  Dim doc As HTMLDocument
  
  ie.Visible = True
  ie.navigate "http://www.buyshedsdirect.co.uk/" &amp; item
  
  Do
      DoEvents
      Loop Until ie.readyState = READYSTATE_COMPLETE
  
  Set doc = ie.document
  On Error Resume Next
  output = doc.getElementByClass("NowValue").innerText
  Sheet1.Range("B2").Value = output
  
  ie.Quit
  
  End Sub
  </code></pre>
  
  <p>i am new to VBA scripting and have no idea why it isnt pulling the value form the class "NowValue"</p>
  
  <p>Any help would be appreciated :)</p>