Reference workbook name

[Guest]

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[Guest]

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

 

[PCLIVE]

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