+ Reply to Thread
Results 1 to 2 of 2

Copy text from a cell paste to website search box and copy & paste results in same sheet

  1. #1
    Forum Contributor
    Join Date
    04-25-2011
    Location
    Donegal, Ireland
    MS-Off Ver
    Excel 2013
    Posts
    133

    Copy text from a cell paste to website search box and copy & paste results in same sheet

    I'd love a bit of code that could help organise this laborious chore that, at the minute, i do manually.

    In the attached Sample.xltm worksheet i'd like to automate using some vba code the 'Client Details' area highlighted in orange, specifically the address in A11 and the email address in A13

    To get the information for these 2 cells I have to look at the data highlighted in blue.

    The email address is within the text in J29 contained within the < > brackets which i'd like extracted and placed in A13

    The address has to be found by copying the text that is always below J59 cell and then go to
    HTML Code: 
    enter it into the search box, hit enter and extract the full address results and paste into A11.

    If this is feasible it would be a great time saver that i could add to other macros that i plan to use.

    Regards
    John
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Copy text from a cell paste to website search box and copy & paste results in same she

    John,

    look here:

    https://www.access-programmers.co.uk...ng-vba.176968/

    that was written long ago. but that was when MS had IE for users and didn't force edge on everyone. per your words:
    enter it into the search box, hit enter and extract the full address results and paste into A11.
    use what is in that link, then right click the text box on the page and ""inspect element"". you see, in FF, what is in the image below. it doesn't look like the input element inside the wrapper DIV has an ID attribute. thus, it looks like you'll have to use NAME. it does have one of those. use the knowledge of what is in the above link combined with these:

    https://www.w3schools.com/TAGs/att_input_name.asp

    https://www.w3schools.com/js/js_htmldom.asp

    to try and get what you need. FYI, this post seems a little suspect, given the purpose of that site. but I responded anyway.

+ 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. Search list for value and then copy and paste text into cell on same row
    By daveb86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2018, 02:36 PM
  2. Replies: 19
    Last Post: 08-02-2018, 10:54 PM
  3. [SOLVED] VBA Loop to search for text then copy and paste in same sheet
    By NerdNinja in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-03-2017, 01:17 PM
  4. Replies: 3
    Last Post: 01-01-2015, 06:26 AM
  5. Replies: 4
    Last Post: 05-16-2014, 06:30 AM
  6. Replies: 2
    Last Post: 10-15-2009, 10:12 AM
  7. Copy and Paste ALL search Results
    By wiredwrx in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-07-2006, 02:45 PM

Tags for this Thread

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