Hey folks,

I am not an expert in VBA, but according to my research, the function I intend to perform will not be possible to do with excel formulas. In this case I will have to dedicate myself to programming in VBA Macros.

I'm looking for a function that tells me the number of files in a specific folder, and put the result in a specific cell on the worksheet.

The exemple :

I want to know how many files i have in this folder :

C:\Users\Veiga\Desktop\Final\PR0015\

And i want the result ( number of files ) in a specific Cell ( D9 ) exemple .

That is the main task for second and better task i want to upgrade the code, the folder PR0015 have more similar folders like : PR0015; PR0016; PR0017; PR0018 ......


So i want to put the folder name in the Cell ( A1 ) exmple
Then i want to know how many files i have in this folder :

C:\Users\Veiga\Desktop\Final\ (A1) \

Like this is a dynamic worksheet where can i change the address

In last task it will be possible to make in the same cell (D9) a droplist with the name of all the files names inside the folder .

Thank you for your help,

Best regards ,

Veiga