Return URL from web search

[Cullen]

Hey everyone,

I have never done much with web searches but need to figure out a way to return the url of the top option from a search on Hoovers.

In column A I have company names like Apple - Putting that into the search field on Hoovers I get Company Search Results - Hoover's.

I need a macro to run that search and the return the url of the first option which is Apple Inc. | Company profile from Hoover's | 408-996-1010 and place it in column B next to the name in text.

Does anyone have any ideas?

Thanks.
Cullen