Rename files based on main folders name

[developer12345]

Hi, all, can you please help me I am very new to vba

What if I have folders name Sanket , Santosh, Zakir
Inside each of these folders above there is a "result" folder
Inside the result folder there is one "salary.pdf" file
I would like to rename the .pdf file inside the result folder into Sanket-salary, Santosh-salary, Zakir-salary,....etc
Then copy all those new renamed file into a master folder.

Is it possible to do that? How do I code?

Thank you in advance!! I really need your help

 

[James006]

Hi,
How to rename file :

VBA Rename File - How to + 5 code examples

VBA allows us access to the windows environment to rename a file. In this post, we look at 5 examples of VBA to rename file methods.

exceloffthegrid.com