Hi everyone, I need a macro that Open a speciefic directory that has several subfolders in it, open each subfolder, open all files, run a speciefic macro that I have, close the file, leave and do it on the next subfolder.

It's something like this:

> open speciefic directory "P:\CONTROLADORIA\FLUXOS EM ANDAMENTO"
> open first subfolder in "PROJETO X1"
> open first file in folder "PROJETO - FLUXO - BRA.xlsm"
> run speciefic macro AJUS
> close file "PROJETO - FLUXO - BRA.xlsm"
> Loop on all files in subfolder "PROJETO X1"
> Close subfolder
> open next subfolder...
< Loop on all subfolder in directory "P:\CONTROLADORIA\FLUXOS EM ANDAMENTO"

That will help me so much!
I'd appreciate it a lot.

Thank you!