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


#1

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


#2

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


#3

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


#4

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


#5

ok great: problem solved!