I have a program which produces (among other things) xml files. I need to
extract specific fields from within each xml file and insert them into an
Excel sheet.

I don't even know how to make a start on this. Each xml is in it's own
folder so I need to extract from each folder in turn. The folders are named
Pat00001, Pat00002 etc. 1 to 500 are in folder called Pats0000, 501 to 1000
are in Pats0001 etc.

Any ideas to get me started. I know it's a tall order, but I just need a
prod in the right direction.

Many thanks in advance

Ian

--

Remove NG from my address to send direct.
-----