The workbook must be saved.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"SharonJo"
wrote in message
I saw a previous question for this, but I need help understanding the formula.
I tried coping this formula, into A1, but--what do I need to change?
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A 1))-FIND("]",CELL("filename",A1)))