PDA

View Full Version : Populate Address From Google Search



decklan5020
12-10-2019, 11:39 PM
Hi everyone,

I'm trying to find some VBA code that will help me populate an address from a list of company names.

In Column A I have all of the company names
In Column B I would like the address to be returned.

Some additional information, all of the addresses should be in TX. I also have my google API key ready to go. I've found some really old posts about accomplishing this in other forums but the results aren't working for me. Specifically this one. Https://stackoverflow.com/questions/24460488/how-to-google-the-street-address-and-return-the-value-back-into-excel-using-exce

Thanks for reading.

Excel Fox
12-12-2019, 09:14 PM
I'll give it a try. Haven't worked with Google APIs (don't give that look ��)