+ Reply to Thread
Results 1 to 2 of 2

Problem with code to search data from excel in website

  1. #1
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2019
    Posts
    756

    Problem with code to search data from excel in website

    Hello,

    I have the code below, which is supposed to enter the text from A1 in my spreadsheet into the textbox on a specific website (which is not actually in the code below, due to Data Protection):

    Please Login or Register  to view this content.
    The element code for the textbox is shown below:

    input data-label="Surname" data-id="Surname" type="text" value="" id="txtSurname" size="30" class="text"

    And the element code for the submit button is below:

    input id="submit-search-nominal-log" type="button" class="button primary-button blue-button" value="Search"

    Can anyone assist me please? I am getting an error on the IE.Document.All("h2").Value = ThisWorkbook.Sheets("Sheet1").Range("A1") line, but I am unsure whether the button click line is correct either.


    Any help appreciated.

    Chris

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Problem with code to search data from excel in website

    Hi Chris,

    You could try:

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

+ 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. Excel VBA to search data in particular website and save(screen shot) result in folder
    By Rajeshb938 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2016, 09:02 PM
  2. Looping through a Website's Search function and pulling data
    By tickersandbonds in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2016, 07:34 PM
  3. [SOLVED] Inputing Data into a Website Search Form
    By WhupTroy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-04-2015, 10:10 AM
  4. Hyperlink to a website search- inserting code to reference one cell.
    By taidog12 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-14-2014, 05:09 PM
  5. Code to copy data from excel to website search box and run it one by one
    By kirtesh250187 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2013, 08:42 AM
  6. Parse Data from HTML Code / Website to Excel
    By rkymtns in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2013, 10:54 PM
  7. Link data in cells to a search on a specific website
    By gideonjav in forum Excel General
    Replies: 1
    Last Post: 10-16-2009, 12:30 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