Take a look he

Worksheet and Workbook names using the CELL() function:
http://www.mcgimpsey.com/excel/formu..._function.html


In article ,
"phica dk" <phica wrote:

How do I get only the filename of the active workbook into a cell.
The "CELL" function returns the name including the whole path.