title: Excel VBA - How to get data from XML URL?
body: <p>I need to get the data from FIELD NAME="sitr2" &amp; FIELD NAME="sitr4". Below is the XML code:</p>
  
  <pre><code>&lt;SEGMENTS&gt;
  &lt;SEGMENT NAME="webcluster"&gt;
  &lt;RESULTPAGE&gt;
  &lt;QUERYTRANSFORMS&gt;...&lt;/QUERYTRANSFORMS&gt;
  &lt;NAVIGATION ENTRIES="0"&gt; &lt;/NAVIGATION&gt;
  &lt;CLUSTERS/&gt;
  &lt;RESULTSET FIRSTHIT="1" LASTHIT="1" HITS="1" TOTALHITS="1" MAXRANK="10000" TIME="0.5673"&gt;
  &lt;HIT NO="1" RANK="10000" SITEID="0" MOREHITS="0" FCOCOUNT="0"&gt;
  &lt;FIELD NAME="rank"&gt;10000&lt;/FIELD&gt;
  &lt;FIELD NAME="personnames"/&gt;
  &lt;FIELD NAME="concepts"&gt;environment;flexible;storage;virtual;growing&lt;/FIELD&gt;
  &lt;FIELD NAME="companyteaser"/&gt;
  &lt;FIELD NAME="locationteaser"/&gt;
  &lt;FIELD NAME="personnameteaser"/&gt;
  &lt;FIELD NAME="nav"&gt;...&lt;/FIELD&gt;
  &lt;FIELD NAME="taxonomy"&gt;t/na&lt;/FIELD&gt;
  &lt;FIELD NAME="documentid"/&gt;
  &lt;FIELD NAME="uniqueid"/&gt;
  &lt;FIELD NAME="sitr1"&gt;4038b5c5-c90b-4ae3-a165-a5e0db9c10d4&lt;/FIELD&gt;
  &lt;FIELD NAME="sitr2"&gt;097cf4a8-2755-4c62-939c-9402e0a4e3e2&lt;/FIELD&gt;
  &lt;FIELD NAME="sitr3"&gt;Unknown&lt;/FIELD&gt;
  &lt;FIELD NAME="sitr4"&gt;0.3&lt;/FIELD&gt;
  &lt;FIELD NAME="sitr5"/&gt;
  &lt;FIELD NAME="sitr8"&gt;&lt;matches&gt; &lt;/matches&gt;&lt;/FIELD&gt;
  &lt;FIELD NAME="int1"&gt;21854&lt;/FIELD&gt;
  </code></pre>
  
  <p>I got no idea where to start. I need to extract and insert into excel. Hope someone could help me.</p>