title: How can I traverse across the XML elements in VBA?
body: <pre><code>&lt;?xml version=&quot;1.0&quot;?&gt;
  
  &lt;Results&gt;
  &lt;Table&gt;
  &lt;VehicleUnitNumber&gt;1&lt;/VehicleUnitNumber&gt;
  &lt;VIN&gt;1D7RB1CT3AS245917&lt;/VIN&gt;
  &lt;OperatingRadius&gt;Local (up to 50 miles)&lt;/OperatingRadius&gt;
  &lt;RegistrationState&gt;FL&lt;/RegistrationState&gt;
  &lt;GaragedState&gt;FL&lt;/GaragedState&gt;
  &lt;ModelYear&gt;2010&lt;/ModelYear&gt;
  &lt;Make&gt;Dodge&lt;/Make&gt;
  &lt;Model&gt;Ram&lt;/Model&gt;
  &lt;VehicleTypeDesc&gt;Private Passenger&lt;/VehicleTypeDesc&gt;
  &lt;WeightClass&gt;Light&lt;/WeightClass&gt;
  &lt;CostNew&gt;45000&lt;/CostNew&gt;
  &lt;/Table&gt;
  &lt;/Results&gt;
  </code></pre>
  <p>Hi. I am new to vba coding and  I have been trying to access the different elements in the XML using vba.
  I have tried out the following code unsuccessfully:</p>
  <pre><code>request.getElementsByTagName(&quot;VehicleUnitNumber&quot;).item(0).text
  </code></pre>
  <p>Any have tried the other solutions on Stack Overflow. Any help is appreciated.</p>