copying data from excel files in folder/subfolders

Hi Guy

im trying to get this macro to copy data from excel files in folders it works but i need it to get data from excel files in sub-folders aswell can someone please help

Thanks

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Describe the process you want to use to achieve your desired results.
For example: The names of the sub folder(s) will be in a range of cells, I choose which cells and the code does the rest or I want to hard code the sub folder names into the code.

That might be a little too much for me.
I'm sure someone with more knowledge than I will pick up the ball here.
If I don't see a response in a couple of hours, I'll send someone a PM and ask them to look at it.

Hi Hannspree,

Because you are wanting to find and import RANDOMLY named data, I'd suggest you try the Application.FindFile method. This will bring up a dialog where you can manually select the file you want to use/import.

See if adding this manual process in your code helps with determining the randomness of your work.

If this doesn't do what you need then look at the "Dir" function. A good example of how it runs through all the files in a directory is at:
http://www.excel-easy.com/vba/exampl...directory.html