I would suggest that you always include a cell reference if you want
a correct answer See comments in italic near the top of
http://www.mvps.org/dmcritchie/excel/pathname.htm
various usages are then supplied to extract workbookname, worksheetname, etc.

If you think it doesn't make any difference because it is all in the same
workbook. That is also an incorrect assumption. Type in your
crippled formula =cell("filename")
then open another workbook, and hit F9, then return to your first
workbook. It will have the values from the second workbook. So
you would want to start with
=cell("filename",A1)
it doesn't matter what cell on the sheet you refer to, all you need is
a reference within the sheet you want to refer to, or the workbook in this case.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"bj" wrote in message ...
look at the help on "Cell()"
=cell("Filename") will give you a filename including path. See if this will
give you want you want

"Barb R." wrote:

I would like to use the "WorkbookName" document property within an excel cell
(if that is the appropriate name). How do I get that name to be displayed
within a cell of my worksheet?

Thanks in advance,
Barb Reinhardt