Automated Export to Excel on Several *.xml Files

[Delnang]

Here is my situation, any help is greatly appreciated!

I have a folder full of completed documents (*.xml files) created with an
InfoPath form. They are job applications. I want to export all of them to
Excel. I know I can do this via the Export command but I want this automated
because I need to do this every two weeks AND I need only certain fields. Is
there a way to set up set export criteria then run this export using a
command button, "Run Export"?
Thank you in advance,
Angie

 

[Ed Richard]

Angie, using Excel 2003 you can open the XML files directly so you can write
a macro in Excel that processes alll the xml-files in the folder.
You could also use Createobject("Microsoft.XMLDOM") and load the files in
the dom for processing, you can do this either in a VB-script or in an Excel
macro.

Ed Richard