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