• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to Combine multiple workbooks into one workbook

Prashantvk123

New Member
Dear all,

Hope all of you are doing well,

I am in search of a macro that combines all the excel files in perticular folder into active workbook irrespective of number of sheets or data.

for e.g. I have a folder named Apr/16 on Desktop and it contains 12 different workbooks with 3 sheets each. I need a macro which can combine all these files into active workbook and give me file with 12*3=36 sheets.

I have checked multiple macros but it seems they are based on range of a workbook which is not what I want.

Please guide me
 
Sorry For the late reply but this example is only copying sheets from open workbooks,
what I need is,
1) Open new workbook and macro workbook
2) Once we run the macro, all the worksheets (from all Workbooks) from particular folder gets consolidated in to active workbook.
 
Back
Top