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.