Address Verification and Distance Calculator in Excel

[NinaE_11]

Hello,
I've got a list of 1500 addresses that I need to legitimize; i.e. ensure entered zip codes are correct and if it's an actual address. Ideally, I'd also like to calculate driving distance in miles/minutes from a single starting point for each of these addresses. Somehow create 'zones' by farthest distance out, etc. Seems like Excel should have this baked in with Geography data, but not sure best approach to pull and calculate.

Any suggestions?

Thanks so much!
Nina

 

[rpaulson]

I used this code a few years back. I think you have to signup with google to use the referances.

How to get Google Travel Time and Distance in VBA by using Google Directions API … Desmond Oshiwambo style

How to get Google Travel Time and Distance in VBA

desmondoshiwambo.wordpress.com