I have read the various online tutorials which decsribe how to opn XML files in Excel 2003 and think that I understand the basics.

But I have not been able to find on the Internet answers to the following questions:

a) If I let Excel interpret the XML schema then it creates a column for every filed in the XML file. Can I, perhaps by creating my own schema for Excel, choose to open certain fields and not others? I have tried this and keep getting errors; but is it my implemetation or is the concept not possible?

b) I have about 50 folders each containing about 50 xml files (all with the same schema). I realise that I can import all the files in a folder at the same time. But can I choose to import all the files in a series of folders at the same time?

Thanks in anticipation.

Chris