I import information pertaining to a shipment. I have to calculate the driving distance between 2 zip codes. Currently I go to mapquest, enter the two zip codes, then paste the distance within my DB. I've looked at applications that calculate the distance, but they do not calculate driving distance, which is what I need.
I'd like to calculate the distance when the data is being imported in . I've looked at Google Maps, and here is what I have now.
I've completed the beginning and ending of this process, I've created the http line and I've imported the xml data into my table
Here's what I need help with
This http request works:
http://maps.googleapis.com/maps/api/...l&sensor=false
How do I execute this http command within VBA, then save the results as an xml file?
Thank you in advance!!