Hi,

Assuming "file.xls" is in A1, type the following in any cell of active sheet.

="'c:\["&A1&"]sheet1'!X1"

and take the result of this cell.

With kind regards,

NAVEEN

"flummi" wrote:

> Hi all,
>
> suppose I have this cell reference: ='c:\[file.xls]sheet1'!X1
>
> and I have the file name "file.xls" in cell A1 on my active worksheet
>
> Is there a way to any of the following:
>
> - include the string in A1 in the above cell reference between the
> square brackets?
> - take the complete path (c:\[file.xls]) from a cell on my worksheet?
>
> or do I have to TYPE the complete path in the above cell reference?
>
> Thanks for thinking about it.
>
> Hans
>
>