Read And Populate XML Values in Excel Sheet Using VB

[Padma Athimoolam]

Hi,

I am new to VB and XML.I want to populate XML Values in Excel Sheet.My Sample XML is
<?xml version="1.0" encoding="UTF-8" ?>
- <workbook>
- <worksheet name="Scorecard _KTC_MW">
<cell name="E9" formula="=sum(G 9,I9,K9)" type="text" />
<cell name="E11" formula="=sum(G 11,I11,K11)" type="Number" comment="Sample Help" />
<cell name="E13" formula="=sum(G 13,I13,K13)" type="General" />
<cell name="G9" value="0" type="text" />
<cell name="G11" value="1" type="Number" comment="Sample Help" />
<cell name="G13" value="3" type="General" />
</worksheet>
</workbook>

eg.I have to Populate Value 0 in Cell name "G9".like that i have to populate other values.Could you please tell me the procedure and guide me to get the results.
Thanks in Advance.