File path in header/footer

  • Thread starter Thread starter AHH
  • Start date Start date
A

AHH

I know that placing &[file] in the custom header/footer
section will automatically print the name of the workbook
when printing the sheet (filename.xls). How can I print
the file name including the complete file path?
(drive:\folder\folder\filename.xls)

AHH
 
It's builtin to xl2002, but in earlier versions, you needed a macro.

And if you don't want to write that macro yourownself, you could use John
Walkenbach's addin that writes it for you:

http://j-walk.com/ss/excel/files/addpath.htm
I know that placing &[file] in the custom header/footer
section will automatically print the name of the workbook
when printing the sheet (filename.xls). How can I print
the file name including the complete file path?
(drive:\folder\folder\filename.xls)

AHH
Click to expand...
 
Back
Top