Hi All,

I've been working on this project for a month and after googling for almost the same period, I have not been successful on finding a formula/VBA code that brings me the data that I am looking for. I hope anyone out there might have the answer to this.

I have a workbook that currently is running a macro that brings me the Path in columna A1, the FIleName of the Path on B1 and the Last Modified date of the File on C1.

After running a Macro I obtain more and less 4K rows of Paths, FIleNames and Dates.

In each of the rows I can find different type of files (.doc, .pdf, .ppt, .xls, .xlsm). I am interested in the ones are Excel files.

The Excel files that I am looking for, have a Cell that’s name "KPIV", so technically if have all the Excel files open I just have to link to the Cell Name based on the Path/FileName and get on Column D1 the value of “KPIV” of each of these Excel Files.

However becasue I have such a big amount of fields (Files) I will take ages to link all the files. In addition, I want to have this Formula/VBA code becasue I want to run the PathList every day and see which "Excel Files" have been saved or if there has been and Update on existing "Excel Files" under "KIPV" cell name.

Thank you in advance for your help.

Calde00a