Hi All, A Very Happy New Year. I am trying develop an excel based tool to get the distance between two location from Google. Both Start & End destination address is available in the excel file. I am using XML to get the job done. Below code is to send the request to Google Maps. xmlRequest.Open "GET", "http://maps.googleapis.com/maps/api/directions/xml?origin=" & SourceAddress & "destination" & "=" & DestinationAddress & "sensor=false", False Code (markup): Now, SourceAddress & DestinationAddress is getting populated from the excel sheet. Also if there is space between the words in the address, I am replacing it with "+". But XML response which i am receiving is "Request_Denied". It seems I am making some mistake in the above code snippet. Requesting your guidance to get is resolved. Regards Sudhir
Hi All, Below is the right syntax for XML request. xmlRequest.Open "GET", "http://maps.googleapis.com/maps/api/directions/xml?origin=" & SourceAddress & "&" & "destination" & "=" & DestinationAddress & "&" & "sensor=false", False Code (markup): Regards Sudhir