How do I display the filename and path in a cell?
Try the below in a saved workbook.
(all in one line)
=LEFT(CELL("filename"),FIND("[",CELL("filename"))-1)&MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)
If this post helps click Yes
---------------
Jacob Skaria
"DianePDavies" wrote:
How do I display the filename and path in a cell? I dont want it in the
header - but I want it in a cell as I want to link to that cell from a word
document.
--
Diane
|