Rename multiple workbooks based on the folder name they are in

[Sevinj]

Hi there,

I have a zip file full of folders named Chapter1, Chapter 2 ... Chapter 26 containing Excel files in them. I want to move all the files from their respective folders to a new folder, but I want the files to be named as "Ch1 Import Data" for example. Is there any way to do this?

Many thanks in advance.

 

[AVK]

I think you need some tool like "kutool".
or use search engine.