title: Select a single node XML object using VBA
body: <p>Hi I'm trying to access the XML response object below</p>
  
  <pre><code>&lt;?xml version='1.0' encoding='UTF-8'?&gt;
    &lt;gfi_message version="1.0"&gt;
      &lt;header&gt;
        &lt;transactionId&gt;123&lt;/transactionId&gt;
        &lt;timestamp&gt;2018-02-08T15:59:41+08:00&lt;/timestamp&gt;
        &lt;processingTime&gt;0.15&lt;/processingTime&gt;
      &lt;/header&gt;
      &lt;body&gt;
        &lt;response name="action1" function="PRICING" version="1.0"&gt;
          &lt;option name="data" ref="price169" /&gt;
        &lt;/response&gt;
        &lt;data format="NAME_VALUE" name="price169"&gt;
          &lt;node name="European Call"&gt;
            &lt;field name="Scenario" value="Trading" /&gt;
            &lt;field name="Currency" value="USD" status="input" /&gt;
            &lt;field name="CtrCcy" value="HKD" status="input" /&gt;
            &lt;field name="Strategy" value="Call" status="input" /&gt;
            &lt;field name="Model" value="Analytic" /&gt;
            &lt;field name="Class" value="European" status="input" /&gt;
            &lt;field name="Direction" value="Buy" status="input" /&gt;
            &lt;field name="Spot" value="7.81241/7.82871" /&gt;
            &lt;field name="Cutoff" value="TOK" /&gt;
            &lt;field name="Market" value="OTC" /&gt;
            &lt;field name="HorDate" value="15:59 Thu 8 Feb 18" status="input" /&gt;
            &lt;field name="ValDate" value="12 Feb 18" /&gt;
            &lt;field name="SpotDate" value="12 Feb 18" /&gt;
            &lt;field name="Maturity" value="Odd Date" /&gt;
            &lt;field name="ExDate" value="8 Feb 18" status="input" /&gt;
            &lt;field name="ExDays" value="0" /&gt;
            &lt;field name="ExTime" value="14:00 SGT" /&gt;
            &lt;field name="DelDate" value="12 Feb 18" /&gt;
            &lt;field name="DelDays" value="0" /&gt;
            &lt;field name="PremDate" value="Mon 12 Feb 18" /&gt;
            &lt;field name="PremType" value="Spot" /&gt;
            &lt;field name="Strike" value="7.81241" /&gt;
            &lt;field name="CtrStk" value="0.128001474576987" /&gt;
            &lt;field name="FwdWealth" value="0\-0.002082079933987" status="input" /&gt;
        &lt;/node&gt;
      &lt;/data&gt;
    &lt;/body&gt;
  &lt;/gfi_message&gt;
  </code></pre>
  
  <p>Specifically I just need <code>&lt;field name="Spot" value="7.81241/7.82871" /&gt;</code></p>
  
  <p>Currently I'm trying to parse and attempt to print the statements in a debugger but I'm not getting any response as well</p>
  
  <pre><code>Dim objXML As MSXML2.DOMDocument30
  Dim nodesThatMatter As MSXML2.IXMLDOMElement
  Set nodesThatMatter = objXML.SelectNodes("//gfi_message/body/data/node")
  
  For Each Node In nodesThatMatter
      Debug.Print nodesThatMatter.SelectSingleNode("field").Text
  Next
  </code></pre>