Macro to append multiple excel files in one excel file

shaukatali shaikh 1 Reputation point
2022-08-12T14:38:02.83+00:00

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
    2022-11-09T21:57:56.037+00:00

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

    258817-xl-pq-pobieranie-z-folderu.png

    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

    Regards

    0 comments No comments