I'm trying to navigate to google then write a place like "supermarket X in State Y" then in google appears an photo of the market and the adress below.
SO I wish to set the store in google than take the adress and set it into a Cell in excel.
My only code to this :
Sub search()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.application")
With IE
.Visible = False
.Navigate ("https://www.google.com")
End With
IE.document.getElementById("lst-ib").Value = "vida"
End Sub
But I got an error is the last line.
Thank's
Aucun commentaire:
Enregistrer un commentaire