How to read xml file using VBA macro

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

 

[Tim Williams]

Plenty of sample code out there. Eg:
http://msdn2.microsoft.com/en-us/library/aa163921(office.10).aspx

Your XML doesn't look valid though. The child nodes of "Details" have no
name, only two attributes "Name" and "Division".

Tim