Merge one sheet from several workbooks in subfolders excluding one subfolder

**ExcelMacrome** · 09-22-2012, 04:54 PM

Hi guys,

I'm very new to the VBA scene so excuse me if this macro is in fact not unique. However in my defense I have searched for days and not found it to be in existence.

What I essential want to do is to create a Macro that will merge all my excel files in a number of different sub-folders into one excel workbook. All the info I need is located in the root folder which houses the sub-folders so all I need is to be able to collect the specific worksheet I want from each excel workbook in the sub-folders and merge them all into one root workbook.

Plus I want to exclude a specific sub-folder so no excel files are collected from it.

So in summary, I have over 200 sub-folders in the root folder and I want to extract just one sheet from each workbook in their respective sub-folders excluding one sub-folder and compile that specific sheet from all sub-folders into a single root workbook. Make sense?? Thanks a lot!!

NOTE: I cannot move the sub-folder from the root-folder which is why I need the macro to ignore it completely.
NOTE: The formatting and naming convention of the sheets in the excluded sub-folders workbooks are the same as the other workbooks in the other sub-folders so I cannot just change the sheet names.