View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aruna Akella Aruna Akella is offline
external usenet poster
 
Posts: 6
Default How to read xml file using VBA macro

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
--
Aruna