Extract street from XML with Excel VBA RRS feed

  • Question

  • with the MSXML2.xmlhttp object (xmlhttp.responseText) I retrieve the next info:

    {"_embedded":{"addresses":[{"purpose":"kantoorfunctie","postcode":"8011PK","surface":11684,"municipality":{"id":"0193","label":"Zwolle"},"city":{"id":"1182","label":"Zwolle"},"letter":null,"geo":{"center":{"rd":{"type":"Point","coordinates":[202908.296,502865.034],"crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:EPSG::28992"}}},"wgs84":{"type":"Point","coordinates":[6.092916,52.5113642],"crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:OGC:1.3:CRS84"}}}}},"nen5825":{"postcode":"8011 PK","street":"GROTE KERKPLEIN"},"addition":null,"number":15,"year":1975,"province":{"id":"23","label":"Overijssel"},"id":"0193200000005017","type":"Verblijfsobject","street":"Grote Kerkplein","_links":{"self":{"href":""}}}]},"_links":{"self":{"href":""}}}

    How can I extract the street "Grote Kerkplein"

    Saturday, July 14, 2018 7:53 PM

All replies

  • Hi,

    This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.



    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Monday, July 16, 2018 2:02 AM
  • Hello pacecal987,

    I note that there are two streets. Which do you want to extract?

    Best Regards,


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Tuesday, July 17, 2018 5:12 AM