title: Scraping data from website using vba 4
body: <p>I am trying to pull minimum nighttime temperature for London from the Met office website using a VBA web scrape. I've tried to use code as posted <a href="https://stackoverflow.com/questions/27066963/scraping-data-from-website-using-vba">here</a>. While the code runs it isnt copying what i need it be copying. Assistance would be much appreciated.</p>
  
  <pre><code>Sub WebScrape_1()
  
  'Create an Internet Explorer browser
  Dim appIE As Object
  Set appIE = CreateObject("internetexplorer.application")
  
  'Browse the browser to the target webpage
  With appIE
      .Navigate "https://www.metoffice.gov.uk/public/weather/forecast/gcpvj0v07"
      .Visible = True ' False activate when happly with code
  End With
  
  'Wait while loading
  Do While appIE.Busy
      DoEvents
  Loop
  
  'What aspect of the webpage to copy
  Set allRowOfData = appIE.document.getElementById("nightValue0")
  
  Dim myValue As String: myValue = allRowOfData.innerHTML
  
  'Close the browser
  appIE.Quit
  Set appIE = Nothing
  
  'Paste the data into the selected range
  ActiveWorkbook.Sheets("Data_Temp").Range("C7").Value = myValue
  
  End Sub
  </code></pre>