lundi 4 janvier 2016

Get the adress with google to excel

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