Hello,

Please help as I am very new to VBA and have mastered only some basic coding. This request is a bit beyond my skills to date...

A macro would open up a dialog box to the xml files; the user would select and open all 100 files. The macro would loop through all selected files, open each one briefly, take only relevant information, store the info in a dynamic Redim Preserved Array, close the xml (renaming it as processed) and move on to the next. After it has looped through all the files, the array would have all the relevant info and the macro would now loop through the array and spill the contents onto a spreadsheet. There are two file sources (50 of each). There are common fields in both that will be used to match the records back together along with the unique data fields in each source.

Of course, the xml files do not actually open in Excel, it only opens in VBA as an instance to be performed on by the program.

Any starting points would be much appreciated.
Thank you!