On Sunday, June 8, 2014 10:57:12 PM UTC+2, GS wrote:
I found this on the search result for vbforums.com. My understanding is

that it returns the 1st search result...



="http://www.google.com/search?q="&A1&"%22&btnI=I%27m+Feeling+Lucky"



..where A1 contains the search criteria. I suspect, though, that you

can convert this from a formula to a hyperlink that opens the search

results page in your web browser...



In A1:

automate google search excel



In B1:



=HYPERLINK("http://www.google.com/search?q="&A1&"%22&btnI=I%27m+Feeling+Lucky","Goog le

Search")



--

Garry



Free usenet access at http://www.eternal-september.org

Classic VB Users Regroup!

comp.lang.basic.visual.misc

microsoft.public.vb.general.discussion

I can't hyperlink the links like that, since the website i am using isn't like google as in "search?q="&A1&"%22&btnI=I%27m+Feeling+Lucky","Goo gle" it's a private website and it doesn't containc /search?q in the url.