Combining multiple files to workbook from folder, including subfolders

Hello,

I'm fairly new to Excel when it comes to VBA programming and I need bit of help with some code.
I have code that combines all excel files from folder into one workbook. Each file to it's own sheet in workbook.

Folder where I have files is D:\Test\ (+subfolders D:\Test\1\, D:\Test\2\ etc.. )

Code works fine to all files what are in D:\Test\, but how can I get it, so that it also searches files from subfolders in directory D:\Test\

Many thanks in advance

Here's the code:

Please Login or Register  to view this content.

Hi
this nice add-in allows you to add sub-folders

Hello Punssiliini,

Welcome to the Forum!

This version of your macro will allow you to select how many Subfolders from the parent folder you want to search.

Please Login or Register  to view this content.

Using the Macro
Here are a few examples of how to set how deep you want to search.

Please Login or Register  to view this content.