Show workbook name??

[JENNYC]

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

[i-Zapp]

enter the following (exactly) into a cell

Please Login or Register  to view this content.

this will give you the entire path, and worksheet.

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

[JENNYC]

thank you! Perfect!!

[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.



JENNYC wrote:
>
> thank you! Perfect!!
>
> --
> JENNYC
> ------------------------------------------------------------------------
> JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
> View this thread: http://www.excelforum.com/showthread...hreadid=479124

--

Dave Peterson