workbook path and footer

[hemsleysut]

How do I insert the filename and path in the footer on only the last printed page of a worksheet printed over several pages and that will be updated automatically if the filename or path changes. Any help will be greatly appreciated.

 

[Andrew Poulsom]

Put either of these formulas at the bottom of the worksheet and include it in the Print_Area:

=CELL("FileName",A1)
=SUBSTITUTE(LEFT(CELL("FileName",A1),FIND("]",CELL("FileName",A1))-1),"[","")