Display Workbook Path and Name in a cell

[RichardBerry]

Hi

Is there a formula to display the Workbook Path and name in a cell that wil update when the file is opened or saved?

[VBA Noob]

Does this link help

http://office.microsoft.com/en-us/ex...030101033.aspx

VBA Noob

[RichardBerry]

Perfect - That is EXCATLY what I was looking for:

'=MID(CELL("filename"),1,FIND("[",CELL("filename"))-1)
&MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

Thank you

[Richard Schollar]

Hi Richard

That formula can be simplified:

=SUBSTITUTE(LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))-1),"[","")

Richard

[RichardBerry]

Hi Richard

That's neat!!!

Thank you

Richard