How to search Google for business name and return address using VBA, Excel
<p>So I have a list of business names in excel starting in cell A2, going down to A3, A4, and so on. What I need to do is retrieve the address for these businesses and return the address in the cell next to it (B2, B3, B4 ...). </p>

<p>I have thousands of business names so I do not want to have to do this manually. Is there a way of searching the web / Google/Bing maps for the business and returning the respective address using VBA. If not, is there any other method I could use to populate my Excel table?</p>