Insert a file path at bottom of page with no [sheet1]

I've set up a macro to add a FileStamp on the last page of my document. The
formula that I used is:

=CELL("filename")

It works great, except that it is too thorough

Is there a different formula that does not add the sheet name information at
the end of the path?

Thanks in advance for any help!

Ewane,

=LEFT(CELL("filename"),FIND("]",CELL("filename")))

Don
"Ewane" <[email protected]> wrote in message
news:[email protected]...
> I've set up a macro to add a FileStamp on the last page of my document.
> The
> formula that I used is:
>
> =CELL("filename")
>
> It works great, except that it is too thorough
>
> Is there a different formula that does not add the sheet name information
> at
> the end of the path?
>
> Thanks in advance for any help!