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!
|