Hi, Thanks for the speedy reply, I am trying to adjust the code i have and am not able to get it working. i am quite new to vba and am struggling to get it working.
i have added
sURL = "https://maps.googleapis.com/maps/api/distancematrix/xml?key="My API KEY"&origins=" & _
and now i get an...
Hi everyone, I have got an API key and wanted to know how to place it into the code to get this working again. any ideas or does somebody have an alternative method of getting the distance between 2 postcodes in ms access.
Thanks in advance
Hi Thanks for the code it works wonderfully but i would like to change it so rather than a message box popup i would like it to automatically update fields in a table.
I want to use the code to calculate my driving distance from my house (zipcode1 Fixed) to various different address's (zipcode2...