+ Reply to Thread
Results 1 to 1 of 1

use content of a cell as an input for a google query and return the URL of the 1st result

  1. #1
    Registered User
    Join Date
    07-13-2012
    Location
    Czech Republic
    MS-Off Ver
    Excel 2010
    Posts
    1

    use content of a cell as an input for a google query and return the URL of the 1st result

    I am looking for an automated solution that will use the content of a spreadsheet cell (A1), will run a query (via google) and will return the url of the website of the first result (of the google search). More specifically: in a cell in spreadsheet, I have the word "Nike". Expected scenario: I run the tool and in the neighboring cell, the tool returns "www.nike.com" and so on for a few thousands of cells, always the most likely website (= the first website in Google search). Thanks for ideas. I can imagine this can be done with a macro: open IE, copy content of A1, run the query and somehow return the url of the first result into neighboring cell (B1). Thanks a lot for help. I tried to look for it in this forum before posting my question but havent seen it so if it has been answered before, just post the link, thanks!

    Bob
    Last edited by Bobv; 07-13-2012 at 02:30 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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