Randy,
As long as the file has been saved at some time, use this formula in your
target cell
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename"
,A1),1))
The A1 is not relevant, it just anchors the formula to the worksheet the
formula is in.
