How to display the xlsc-filename in the header of the spreadsheets?

Is there a way of obtaining the xlsc-filename for displaying in the spreadsheets after reopening them? I am aware, that the padlock title bar shows this filename. However I would like to have it displayed in the header (or in a cell) of the spreadsheet itself. If necessary by using a macro. Only this would later allow to establish the allocation of a print out or a pdf with the corresponding xlsc-file.

Regards

Sure, the solution exists in the XLS Padlock user guide PDF file:

Thank you, works fine.
My File is the filename including its path.
How can I get the filename without path?

hpkpf said:

How can I get the filename without path?

Click to expand...

See http://vba-tutorial.com/parsing-a-file-string-into-path-filename-and-extension/

ok great: problem solved!