+ Reply to Thread
Results 1 to 3 of 3

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

  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?:


    Please Login or Register  to view this content.
    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

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

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


    Hi,

    an example : Internet Explorer Automation using Excel VBA

    Regards !

  3. #3
    Registered User
    Join Date
    04-17-2014
    Location
    Sweden
    MS-Off Ver
    Excel 2013
    Posts
    6

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

    Thanks!!!!!!!!

+ Reply to Thread

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. [SOLVED] 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