How to read xml file using VBA macro

  • Thread starter Thread starter Aruna Akella
  • Start date Start date
A

Aruna Akella

I have an xml file (below is the the sample) - how do I read this XML file to
get "id", "name" and "division" values using VBA macro? Any sample code is
really appreciated. Thanks!

<CustomerDetails>
<cid id = "A123">
<Details>
<Name = "John" Division = "xyz"/>
<Name = "David" Division = "rts" />
</Details>
</cid>
</CustomerDetails>
 
Back
Top