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

hpkpf · January 24, 2018, 8:22pm

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

gdgsupport · January 27, 2018, 11:21am

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

hpkpf · January 29, 2018, 3:20pm

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

gdgsupport · January 31, 2018, 2:51pm

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

hpkpf · January 31, 2018, 6:03pm

ok great: problem solved!