| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening macro file as read only | Excel Programming | |||
| how to read dbf file using macro? | Excel Programming | |||
| macro read xml file | Excel Programming | |||
| How to write a macro to open a file read-only? | Excel Programming | |||
| Saving a file within a macro but only when it does not have a read only attribute | Excel Programming | |||
Linear Mode
