How to parse XML in VBA
- by dev
Hi, I work in VBA, and want to parse a string eg
<PointN xsi:type='typens:PointN'
xmlns:xsi='<http://www.w3.org/2001/XMLSchema-instance>'
xmlns:xs='<http://www.w3.org/2001/XMLSchema>'><X>24.365</X><Y>78.63</Y></PointN>
and get the X & Y values into two separate integer variables.
I'm a newbie when it comes to XML, since I'm stuck in VB6 and VBA, because of the field I work in.
How do I do this?