Show workbook name??

J

JENNYC

Hi! I think this should be a fairly easy question: Is there a simpl
formula too show the workbook name? I know you can do it in th
header/footer area but i need it to show up in a cell. Any help i
greatly appreciated! Thanks
 
I

i-Zapp

enter the following (exactly) into a cell

Code
-------------------
=CELL("filename"
-------------------


this will give you the entire path, and worksheet.

then use some text functions to trim out the workbook name
 
D

Dave Peterson

I think you'll be better off including a cell reference:

=cell("Filename",a1)

If you don't include that last reference, then this formula will evaluate to the
workbook that was active during the last calculation.

If you open two workbooks and put:
=cell("Filename")
in A1 of a worksheet in each workbook
then use window|arrange|tiled
to see both worksheets,
you'll see the difference.
 
Top