Excellent point!
"Bob Tarburton" wrote:
=CELL("filename")
Careful, if you don't use a cell reference on the sheet this formula
will show the path/file/sheet you were on when you last recalculated.
Also, switching back to the sheet or printing will not automatically
recalculate.
"Mark" wrote:
Hi,
Is there a way to program a cell to see and display the current name
of it's Excel file? Similar to the option displaying it in the header
or footer, I would like to display the file name in a cell of the
spreadsheet itself.
Any help would be appreciated.
Thanks in advance,
Mark
|