title: VBA - HTML scraping problems
body: <p>I'm attempting to scrape auction data from a website <a href="https://www.rbauction.com/heavy-equipment-auctions" rel="nofollow noreferrer">https://www.rbauction.com/heavy-equipment-auctions</a>. My current attempt was to use the below code to pull the website's HTML into VBA and then parse through it and keep only the items I wanted (auction name, number of days, number of items).</p>
  
  <pre><code>Sub RBA_Auction_Scrape()
  
      Dim S_Sheet As Worksheet
      Dim Look_String As String
      Dim Web_HTML As String
      Dim HTTP_OBJ As New MSXML2.XMLHTTP60
  
      On Error GoTo ERR_LABEL:
      Set S_Sheet = ActiveWorkbook.ActiveSheet
      Web_HTML = ""
      HTTP_OBJ.Open "GET", "https://www.rbauction.com/heavy-equipment auctions", False
      HTTP_OBJ.Send
      On Error Resume Next
      Select Case HTTP_OBJ.Status
          Case 0: Web_HTML = HTTP_OBJ.responseText
          Case 200: Web_HTML = HTTP_OBJ.responseText
          Case Else: GoTo ERR_LABEL
      End Select
  
      Debug.Print Web_HTML
  
  End Sub
  </code></pre>
  
  <p>It successfully pulls in the data, but the 'upcoming heavy equipment auction' section that has all of the names and sizes of the auctions does not get pulled into VBA. I'm not very good with HTML in general but I was hoping someone could offer a solution or at least an explanation as to when I search through the website HTML that is pulled into VBA, the articles that I want are not found.</p>