hi,
Here is a formula that i use to do that.

=('S:\PUBLIC\Ae-pc\WOR\fy05\[WORJun05.xls]WCon'!$AS$2)

you can adjust it to fit your data. it uses file path in the formula.
note the single quotes around the path up to sheet number and the file name
in brackets.

Regards
FSt1
"learnexcel" wrote:

1. I am working on file F1 and Cell A1 contains a file name (fname).
2. I want to extract the contents of cell B2 on fname (which has not been
opened!)and put it onto cell B2 of file F1.

How do I do this ?

- I used concatenate to evaluate '<fname but it does not work
- I used Indirect function, but it works only with opened files

Regards