ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   use content of a cell as an input for a google query and return the URL of the 1st re (https://www.excelbanter.com/excel-programming/446562-use-content-cell-input-google-query-return-url-1st-re.html)

bobv

use content of a cell as an input for a google query and return the URL of the 1st re
 
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


All times are GMT +1. The time now is 08:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com