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...

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...

Laurent Longre has a utility called MOREFUNC which provides a INDIRECT.EXT
UDF which should do what you want, and you can find it at

http://xcell05.free.fr/


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gordon" wrote in message
...
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...