How to parse XML using vba

by

Thanks for the pointers.

I don’t know, whether this is the best approach to the problem or not, but here is how I got it to work.
I referenced the Microsoft XML, v2.6 dll in my VBA, and then the following code snippet, gives me the required values

Dim objXML As MSXML2.DOMDocument

Set objXML = New MSXML2.DOMDocument

If Not objXML.loadXML(strXML) Then  'strXML is the string with XML'
    Err.Raise objXML.parseError.ErrorCode, , objXML.parseError.reason
End If
 
Dim point As IXMLDOMNode
Set point = objXML.firstChild

Debug.Print point.selectSingleNode("X").Text
Debug.Print point.selectSingleNode("Y").Text

More Related Contents:

  1. Best XML Parser for PHP [duplicate]
  2. Why is it such a bad idea to parse XML with regex? [closed]
  3. How to fix error: The markup in the document following the root element must be well-formed
  4. How do I convert an ISO8601 TimeSpan to a C# TimeSpan?
  5. Read a XML (from a string) and get some fields – Problems reading XML
  6. XML Namespace URI with HTTPS?
  7. how to edit XML using bash script?
  8. XML parse VBA excel (function trip, & MSXML2.DOMDocument)
  9. Are line breaks in XML attribute values allowed?
  10. Parsing XML using unix terminal
  11. What browsers support Xpath 2.0?
  12. “Content is not allowed in prolog” error yet nothing before XML declaration
  13. Convert image (jpg) to base64 in Excel VBA?
  14. VBA Output to file using UTF-16
  15. VBA pull XML data to Excel
  16. android sdk main.out.xml parsing error?
  17. Can a XML element contain text and child elements at the same time?
  18. Using CDATA inside another CDATA
  19. Parsing local XML file using Sax in Android
  20. Parsing XML with namespace in Python via ‘ElementTree’
  21. Is there any difference between ‘valid xml’ and ‘well formed xml’?
  22. xml.LoadData – Data at the root level is invalid. Line 1, position 1
  23. External referenced DTD in XML
  24. Html inside XML. Should I use CDATA or encode the HTML [closed]
  25. How do I define HTML entity references inside a valid XML document?
  26. Simplify PHP DOM XML parsing – how?
  27. What are the best practices for versioning XML schemas?
  28. What is the purpose of XSD files?
  29. SVG Scaling Text to fit container
  30. XSLT Transformation – dynamic element names

Leave a Comment