Inserting File Path in Workbook


Posted by Mary Dawson on June 13, 2001 6:00 AM

How can I insert the File Path in the Workbook?



Posted by Aladin Akyurek on June 13, 2001 6:48 AM

CELL("filename")

or

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

Aladin