Hi!
Im extreme new to VBA, so please bare that in mind=)
Im trying to use this homepage: www.booli.se (a homepage where you can search for areas in Sweden and then see which apartments has been sold there lately).
What I want: when I write a word in excel, like the area "Stockholm", i want the internet explorer to start and go to the webpage (www.booli.se) and write the exact same word (Stockholm) in the searchbox and finally clicking Search.
Problem: I cant get the word (Stockholm) in the searchbox on the webpage! I cant find the ID-tag name..I have tried everything.
This is my code, what is wrong?:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = Range("city").Row And _
Target.Column = Range("city").Column Then
Dim IE As New InternetExplorer
IE.Visible = True
IE.navigate "http://www.booli.se/"
Do
DoEvents
Loop Until IE.readyState = READYSTATE_COMPLETE
Dim field As Object
Set field = doc.getElementById("custominput")
End If
So my problem is that I cant find the correct ID on the searchbox. Everything works until "Set field = doc.getbyelement......".
PLease help a young rookie!
Best regards from Sweden
Bookmarks