Dear all,

I would like to find some statistic of data from multiple XML files
using Excel 2007. I want to import all the files in a folder and sub-
folder into one EXCEL spreadsheet. Each XML file has the identical
structure, but different data. I want to define the XML map in Excel,
and import data for each file, with each file's data being on a new
row.

By the way, it seems that excel does not allow to import many files at
once. :(

Any hints?

Thanks in advance.

Mungkol

Hi Mungkol

You can try the code here and change the extension in the code to xml
http://www.rondebruin.nl/fso.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Mungkol" wrote in message ...
Dear all,

I would like to find some statistic of data from multiple XML files
using Excel 2007. I want to import all the files in a folder and sub-
folder into one EXCEL spreadsheet. Each XML file has the identical
structure, but different data. I want to define the XML map in Excel,
and import data for each file, with each file's data being on a new
row.

By the way, it seems that excel does not allow to import many files at
once. :(

Any hints?

Thanks in advance.

Mungkol

Thanks, I'll give it a try :)

Regards,

--Mungkol

Actually you can import multiple xml files into Excel (at least I could in
2003). If the files have identical structure create a map from any of them.
Then just import the files you want through Data - XML - Import. The files
should be located in one folder just select as many as you like.

"Mungkol" wrote:

Dear all,

I would like to find some statistic of data from multiple XML files
using Excel 2007. I want to import all the files in a folder and sub-
folder into one EXCEL spreadsheet. Each XML file has the identical
structure, but different data. I want to define the XML map in Excel,
and import data for each file, with each file's data being on a new
row.

By the way, it seems that excel does not allow to import many files at
once. :(

Any hints?

Thanks in advance.

Mungkol