Macro to append multiple excel files in one excel file

shaukatali shaikh 1 Reputation point

I have a folder having multiple excel files each having one single worksheet which contains exact data with same columns. i want a macro to help append all the excel files data one below the other into one new excel file .
I tried using vba code from "Append data from multiple excel files RRS feed
Archived Forums 421-440 > Visual Basic for Applications (VBA )". But it is not working

kindly help

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,473 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Oskar Shon 866 Reputation points MVP

    You can do it easy using Power Query. That for a start:


    If you must do it in code then loop, open files, find data on tabs and copy to single one. That is not easy way.
    I create tool for it before PQ exist: hQlGjMo8fws


    0 comments No comments