Hello,
This code works perfectly to scrape data from a website and it shows it via a msgbox:
Sub Data_scraper()
Dim IE As New InternetExplorer
Dim ieDoc As HTMLDocument
With IE
.Visible = False
IE.navigate Sheets("Sheet1").Range("G54").Value
Do Until .readyState = 4: DoEvents: Loop
Set ieDoc = .document
MsgBox ieDoc.getElementsByClassName("editorLabel")(0).innerText
End With
IE.Quit
End Sub
However, after testing I would now like the data from my Msgbox to go into a cell on my worksheet. How would I go about doing this?
Bookmarks