Not sure exactly what you're asking, but this is how to refer to cell A1 of
Sheet 1 in a workbook with a file name of "Test.xls".

='[Test.xls]Sheet1'!$A$1




"Chris" wrote in message
...
Is there a function that references a workbook's name?