Converting Text into a filename

[stanleyford]

I have a valid filename stored in a cell. I want to concatenate it
with a specific cell reference and use the resultant string to get the
cell's value in the correct filename. Due to the number of files I
need to access this way, I cannot have them open and use the INDIRECT()
function.

Is there another way to have excel recognize a text string as a
filename and cell reference?

Thanks in advance!

 

[JE McGimpsey]

I have a valid filename stored in a cell. I want to concatenate it
with a specific cell reference and use the resultant string to get the
cell's value in the correct filename. Due to the number of files I
need to access this way, I cannot have them open and use the INDIRECT()
function.

Is there another way to have excel recognize a text string as a
filename and cell reference?

One way, using macros:

http://www.mcgimpsey.com/macoffice/excel/getcellvalue.html