Reference workbook name

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

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

--
HTH

Bob Phillips

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

"Chris" <[email protected]> wrote in message
news:[email protected]...
> Is there a function that references a workbook's 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?

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" <[email protected]> wrote in message
news:[email protected]...
> Is there a function that references a workbook's name?