View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default How to read xml file using VBA macro

Plenty of sample code out there. Eg:
http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx

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

Tim


"Aruna Akella" wrote in message
...
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