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...