In Excel 2007, you can use the following formula to achieve the question requirements:

=MID(CELL("filename",$A$1),FIND("]",CELL( "filename",$A$1))+1,66)

Note 1: This formula is for archived files.

Note 2: This formula is for any worksheet of the active file

The result of the formula is as shown below:

Image of the formula result 1

Image 2 of formula results