How to read xml file using VBA macro

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro via VBA - XML IMPORT 13
read xml method-- faster one 1
VBA Macro to retrieve information from xml file 1
Read/Write variables to XML with VBA 1
use vba to open pdf then save as xml 4
Read/Write variables to XML file using VBA 1
read xml and fill valuesin excel form combobox 5
VBA calling a web application that returns XML 5

Top