Find and read excel files in a specific folder

Hey

Is there a easy way to have a cumulative excel workbook that adds specific cells from excel workbooks (sheets are identical in each workbook) that are named randomly.

For example. In a cumulative workbook, I would like to have a cell that adds all values in C11 on each workbook that is in c:\example\

Is it too far fetched?

-Kansalainen-

hey

thanks for the video, good advices, but I probably explained it too narrowly.

Folder c:\example has today 50 excel workbooks (all have same sheets) and number of files increses everyday. Is there a formula that checks automatically each files "C11" for example and adds them up or does what I want with the numbers?

-Kansalainen-

hi

Thanks for the help. learned again something new.

i pasted that code to excel (right clicked "view code" on sheet1) and couldnt get it to work.

I created 3 excel files, Book1, Book2 and Book3. I put "5" in to each "K5". Then I used that code to this fourth "All" workbook and it didnt work.

should i make some adjustments to this code or what?

Thanks for the help, and i know i am a tool

-Kansalainen-