troubleshooting Question

Retrieve values from XML response to Google Maps

Avatar of Dale Fye
Dale FyeFlag for United States of America asked on
2 Comments1 Solution115 ViewsLast Modified:
I'm pulling data from the Google Map API and it returns an XML response which looks like:
 <origin_address>Grafton, VA 23692, USA</origin_address>
 <destination_address>Yorktown, VA 23690, USA</destination_address>
    <text>9 mins</text>
    <text>9.8 km</text>

Open in new window

I would like to extract the duration/text and distance/text values from this XML but the code found is using is not returning those values
    Dim domResponse As DOMDocument60
    Set domResponse = New DOMDocument60
    domResponse.loadXML objXMLHTTP.responseText
    Dim ixnStatus As Variant
    Set ixnStatus = domResponse.selectSingleNode("//status")
    If ixnStatus.Text = "OK" Then
        Dim ixnDistance, ixnDuration
        Set ixnDistance = domResponse.selectSingleNode("/DistanceMatrixResponse/row/element/distance/text")
Debug.Print ixnDistance
        Set ixnDuration = domResponse.selectSingleNode("/DistanceMatrixResponse/row/element/duration/text")
Debug.Print ixnDuration
    End If

Open in new window

and actually raises an error (#438          Object doesn't support this property or method) on line 11
I'm sure this is just a matter of getting the "SelectSingleNode" argument correct, but I have played with just about every combination of nodes names and cannot get this right.
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros