Footer - FileName and Path

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Friends,

Is there a way to insert not only the file name but also the path into an
Excel Worksheet footer (like you can in Word)?

Thanks,

Bill Morgan
 
This code, placed in the ThisWorkbook code module, automatically picks up
the cell value when printing.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = Activeworkbook.FullName
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Bill

Also FYI

If you are running Excel 2002 or 2003 there is a button for entering the full
path into a footer/header in the header/footer Custom setup dialog.

Gord Dibben Excel MVP
 
Thanks, Bob. I'll put this to work.

Bob Phillips said:
This code, placed in the ThisWorkbook code module, automatically picks up
the cell value when printing.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = Activeworkbook.FullName
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
Gord,

I should have mentioned that this is Excel 2000 - but good to know that
later versions have this feature - thanks ...
 
Back
Top