Hi,

Can someone please help me with the vba code on how to parse values for entry, visits, displaymboxes, conversion and sumofsquares amount in to excel.

My xml look like this.

<reports>
<report campaignId="44" start="2013-08-16" end="2013-08-25" resolution="day" type="IMPRESSION">
<sample start="2013-08-16T00:00" duration="day">
<recipe name="Tablet (Direct)" id="0" trafficType="TESTING" algorithmId="0">
<description/>
</recipe>
<recipe name="Tablet" id="1" trafficType="TESTING" algorithmId="0">
<description/>
<step name="Entry">
<count>40035</count>
</step>
<step name="Visits">
<count>31792</count>
</step>
<step name="Display mboxes">
<count>40035</count>
</step>
<conversion name="Conversion">
<count>105</count>
<amount>10792.04</amount>
<sumOfSquaresAmount>11168459.8816</sumOfSquaresAmount>
</conversion>
</recipe>
</sample>
</report>
</reports>

Thanks
Chaitanya Kayasri.