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!

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

Ewane,

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

Don
"Ewane" wrote in message
...
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!