Import Multiple XML Files

I'm trying to write a macro that would import multiple XML files from a single folder into Excel. The current path I would use would be to go to Data->From Other Sources->From XML Import and then select each individual file. I'm looking for a way to do this entire folder at once. Any help on starting this macro out would be helpful.

It turned out to be pretty simpe to write. Here's how I did it:

Please Login or Register  to view this content.