Hi
I have folder which have 231 subfolder. Every subfolder have some files in it.
I need some solution to create 231 excel file (one in every subfolder) with file list from this subfolder.
Column is:
A1:B1:C1:D1
"IME SLIKE" , "ILUSTRATOR" , "OPIS" , "KLJUČNE RIJEČI"

Have macro which create file list from subfolders but this create only 1 excel doc.

thanks

current is:
Root
...folder1
...folder2
...etc...

need to be:
Root
...folder1
......folder1.xls
...folder2
......folder2.xls
etc...