Dear all,

Good day. I just learned how to generate files using VBA and everything goes smoothly. However, i had a little problem when comes to extracting specific datas from file/files. May i know how should i able to extract specific data from xml document and put it into excel using VBA?

Example of xml file:

<name>john</name>
<country>canada</country>
.
.
.
<Name>cyntia</name>
<country>england</country?
.
.
.

Output that wish in excel:
name country
john canada
cyntia england

Thanks in advance.