Dim ie As New InternetExplorer
Dim doc As HTMLDocument
Dim span As Object
Dim elements As IHTMLElementCollection
Dim element As IHTMLElement
Sheets("Import").Select
Cells.Delete
Range("A1").Select
ie.Visible = True
ie.Navigate "AUCTION(S) SEARCH RESULTS | Rum Auctioneer" & SearchTerms & "&sort=field_reference_field_end_date+DESC&items_per_page=500"
Do
DoEvents
Loop Until ie.readyState = READYSTATE_COMPLETE
Set doc = ie.Document
Set elements = doc.getElementsByClassName("view-content")
For Each element In elements
ActiveCell.Value = element.innerText
ActiveCell.Offset(1, 0).Select
Next element
ie.Visible = False
ie.Quit
Set ie = Nothing
A good example URL might be:
AUCTION(S) SEARCH RESULTS | Rum Auctioneer
rumauctioneer.com
Trying to scrape info from this web site. Whatever I try, span, div, class, element, everything seems to end up written into cell A1. I'd like to have a new line for each item in the grid or even for each innerText item. Can you help please? I'm not that well versed in HTML so I've been bodging so far. Thanks in advance.