title: VBA HTML Data Scrape Guidance
body: <p>I'm attempting to extract data from the following site using VBA, by inputting a city, and having selected results outputted into excel cells. I'm very new to this, and this my third attempt, but now I'm getting a "Object Required" error when I try to run it. I've stepped through it, and it throws the error at, of course, the IE object I tried to create. Any suggestions on what I can do to tweak my code? Any help would be much appreciated! Thank you. </p>
  
  <h2>Code</h2>
  
  <pre><code>Private Sub CreditUnion()
  
  If Target.Row = Range("City").Row And Target.Column = Range("City").Column Then
  
      Dim IE As Object
  
      Set IE = CreateObject("internetexplorer.application")
  
  
      IE.Navigate "http://mapping.ncua.gov/SingleResult.aspx"
      IE.Visible = False
  
      Do While IE.Busy
  
          DoEvents
  
      Loop
  
      Set TableResults = IE.document.getElementsByID("MainContent_newDetails")
  
      Dim City As String: City = TableResults.Cells(17).innerHTML
      Dim CreditUnion As String: CreditUnion = TableResults.Cells(0).innerHTML
      Dim Region As String: Region = TableResults.Cells(9).innerHTML
      Dim Status As String: Status = TableResults.Cells(3).innerHTML
      Dim Assets As String: Assets = TableResults.Cells(13).innerHTML
      Dim Members As String: Members = TableResults.Cells(15).innerHTML
  
  
      Range("B1").Value = City
      Range("C4").Value = CreditUnion
      Range("D4").Value = Region
      Range("E4").Value = Status
      Range("F4").Value = Assets
      Range("G4").Value = Members
  
  
      IE.Quit
      Set IE = Nothing
  
  End If
  
  End Sub
  </code></pre>
  
  <hr>
  
  <p>Code can't get past this point
  [Code stuck here][1]</p>
  
  <p>We're getting close! made it past the first screen. It's just not pulling in the data now in the case statements
  [enter image description here][2]</p>