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/distancematrix/xml?origins=77074&destinations=24112&units=imperial&sensor=false
How do I execute this http command within VBA, then save the results as an xml file?
Thank you in advance!!
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/distancematrix/xml?origins=77074&destinations=24112&units=imperial&sensor=false
How do I execute this http command within VBA, then save the results as an xml file?
Thank you in advance!!
Last edited: