Reference workbook name
 

Is there a function that references a workbook's name?

Reference workbook name
 

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob Phillips

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

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

Reference workbook name
 

Are you saying you want to have the workbook name show up in your worksheet
somewhere? If so, use the CELL function

Try something like this
=CELL("filename",A1)

You can parse out the workbook name from that

"Chris" wrote:

Is there a function that references a workbook's name?

Reference workbook name
 

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?