View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Don is offline
external usenet poster
 
Posts: 19
Default 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!