into one worksheet Microsoft's how-to section has limited help in how to write macros so I was wondering if there might be another way to do this.

I've been able to select multiple files from one folder and import in one worksheet. I also tried doing a search for all of the files in the subdirectories of the primary folder and tried highlighting the search results and dragging and dropping into excel but a new worksheet would open for each xml file.

I did a search in here and didn't see another situation like this in here. Thanks for any assistance you can provide.