ExcelBanter - How do I print a filename at the end of the file (not every page)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I print a filename at the end of the file (not every page) (https://www.excelbanter.com/excel-worksheet-functions/84865-how-do-i-print-filename-end-file-not-every-page.html)

sanfranson

How do I print a filename at the end of the file (not every page)

I know how to print a dynamic file name in a footer but that doesn't solve my
issue. I can't find an option to print footers just at the end of a file. I
can't find a function like the date/time where you can insert a dynamic file
name in a cell.

Dav

How do I print a filename at the end of the file (not every page)

=CELL("filename")

Returns the filename of the spreadsheet and the path. Not sure if that
helps

Regards

Dav

--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=535543

ufo_pilot

How do I print a filename at the end of the file (not every page)

=CELL("filename",A1)

"sanfranson" wrote:

I know how to print a dynamic file name in a footer but that doesn't solve my
issue. I can't find an option to print footers just at the end of a file. I
can't find a function like the date/time where you can insert a dynamic file
name in a cell.

All times are GMT +1. The time now is 02:43 AM.