Automatically display file name

[Badnames]

How can I automatically display the filename of the current workbook in a cell on a worksheet? I.e. when my file name is Excelsheet8-4-2011, I need cell A1 to show 'Excelsheet8-4-2011'.

 

[ExcelRoy]

Hi Badnames,

Try
http://www.mrexcel.com/forum/showthread.php?t=7526

Hope this helps

 

[Nalani]

Maybe as simple as:

=CELL("filename")

Placed in your cell of choice