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