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
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