vba code to copy from each file with xml extension in folder to another excel file in a master worksheet

[steamrogue]

I'm trying to find and figure out the vba code needed to copy entire rows from multiple files with xml extension, but each file has different numbers of rows, some file have 1 row, another file have multiple rows. All of these xml files are in a folder and i want to copy all of the data in a master excel sheet.



Thanks!!

 

[Fluff]

Duplicate to: excel vba to copy from a specific folder from multiple workbooks to a master workbook

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.