title: How to Google the street address and return the value back into Excel using Excel VBA?
body: <p>I have a list of over 50,000 places in Excel (eg. Arches National Park, Cornell Museum of Glass). When I type "Cornell Museum of Glass" into Google, it returns an address of "1 Museum Way, Corning, NY 14830". I need the full street address <strong>Street #, Street name, and postal code</strong>. I do have the state NY though(in Excel). Does anyone know how to search the address on Google(typing Cornell Museum of Glass), then return the street address back onto Excel(1 Museum Way, Corning, NY 14830)? I know VBA is capable of doing this, and I don't want to manually do it 50,000 times, plus I'm a total newbie at VBA. If anyone knows how I would greatly appreciate it! Thank you in advance.</p>