Get value from closed workbook based on filename?

[Novo]

I have an open workbook that lists the file names of hundreds of other closed workbooks in a column. Inside each closed workbook there is a cell that has a value of TRUE or FALSE. I need to make each cell in the open workbook with a matching filename value format to red or green based on the TRUE/FALSE condition in each closed workbook.

Since there are hundreds of closed workbooks, I would like for the function to be able to compare the value of the cell in the open workbook to all of the files in a folder. Then, when it sees a filename that is equal to the value of the cell in the open workbook column, it returns the TRUE/FALSE value from the cell in the closed workbook of that filename.

Please help.

[D_Rennie]

so you have a cloum of file names.
1st question are these fully qualified, ie D:\Folder\Filename.xls
2nd do you want the True/False to be returned next to the corrsponding cell.

you can use

Please Login or Register  to view this content.

to retrive the cell info for that file.

If you need further help post a sample workbook outlining what you have and where you want to get.