Hi to everyone,

I have been looking for a solution for the above problem for the past few days but haven't found a solution so I am turning for help. I have found some relevant macros but haven't been able to modify them successfully.

I am looking for a macro that loops through all sub-folders of a main folder, the levels of sub-folders can be anything from 1 level to sometimes more than 5 levels, and perform an action. In this case I would like to rename the first sheet of each workbook the same as the workbook name.

Any help is greatly appreciated, many thanks!