cycling through all sub-folders in a folder

Hi all,

I have a macro (lets call it weatherdata) to perform certain functions on a given folder containing a number of text files that I import to excel and manipulate.

This must be run for each folder contained within a main folder.

To speed things up I would like a macro which identifies all sub-folders within a particular main folder
(lets call its location C:\test macro),
runs my macro for the first given subfolder, then moves on to the next sub-folder and runs the macro again and so on until all the sub-folders in the main folder have been gone through.

The main folder name will stay constant, however the sub-folder names will be variable.
All sub-folders should have the macro performed on them (i.e. I don't need to avoid any sub-folders), however if they could be cycled through by order of name (a-z) this would be benificial (though not essential).

I hadn't expected this to be so difficult, I would use a "With Application.FileSearch" but I am looking to cycle through folders not files!

Usually I'd just search the forums and adapt something, but I've searched for a while now with no success so I'm biting the bullet and posting!
I'd really appreciate any suggestions.

Ben

To get all files in all subfolders of C:\test macro:

Please Login or Register  to view this content.

So why don't you:

Please Login or Register  to view this content.