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