Footer - FileName and Path

B

bill_morgan_3333

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
 
B

Bob Phillips

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)
 
G

Gord Dibben

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
 
B

bill_morgan_3333

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...
 
B

bill_morgan_3333

Gord,

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