Hey guys

I have seen a various VBA codes which do a part of what I am trying to achieve, but I couldn't find anything that helps me to do exactly what I want.

I have got a folder with around 500 excel files (all with a same template) (apart from excel files there are some other subfolders too in this folder). The address of that folder on my computer is \\STM-FS2\shared documents\shared documents\JOB COSTINGS. Now I want to fetch data from cells C4 and O17 from a worksheet named Hours from each file in that folder.

Please help me with a code that do this.

Thanks