Hi Gordon

Use INDIRECT function

Thanks
Xcelion




"Gordon" wrote:

In cell A2 I have a value/filename (which I created by having code grab all
file names in a folder). I now need to use this value/file name to suck data
out of the files in this folder without having to open every file to get an
initial link. Somehow, I can't get the examples of the formulas below to
work. How can I get directory path presented simply as text to become an
active link that can be pasted into formulas without creating a hyperlink
from each - there are 3000 files.

EG

Value/File Name In A2 C:\Desktop\Product1.xls

In B2 I need to pick cell information within this file.
='[A2]$B$2
In C3 I need to pick cell information within this file.
='[A3]$B$3

Thanks in advance...