Results 1 to 3 of 3

Rookie VBA question - Trouble entering excel data in to a searchbox on a webpage

Threaded View

andba731 Rookie VBA question - Trouble... 04-17-2014, 12:11 PM
Marc L Re: Rookie VBA question -... 04-17-2014, 02:31 PM
andba731 Re: Rookie VBA question -... 04-18-2014, 08:52 PM
  1. #1
    Registered User
    Join Date
    04-17-2014
    Location
    Sweden
    MS-Off Ver
    Excel 2013
    Posts
    6

    Rookie VBA question - Trouble entering excel data in to a searchbox on a webpage

    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
    Last edited by Leith Ross; 04-17-2014 at 12:42 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Create Macro, Userform or a searchbox to search data from table in excel in diff sheets
    By hanif in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 03-25-2014, 06:21 AM
  2. Another Rookie Question
    By Trishay321 in forum Access Tables & Databases
    Replies: 1
    Last Post: 01-28-2009, 07:20 AM
  3. A code question from a rookie
    By SuitedAces in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-02-2006, 02:50 AM
  4. [SOLVED] Excel Rookie Question
    By Ron in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-24-2006, 01:55 PM
  5. VBA Question (rookie issue)
    By Scott Wagner in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2006, 07:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1