File Name and Path

[Stacy O]

Is there a way to add the path to a file name in an Excel
footer? We are using Office 2000. Thanks.

 

[Ron de Bruin]

Hi Stacy

http://www.j-walk.com/ss/excel/tips/tip22.htm

See John's tip on this for Excel 97-2000
Excel 2002/2003 have this option build in

 

[Bob Phillips]

Stacy,

You can use VBA to set the BeforePrint to print the same footer

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

Put this in ThisWorkbook code module

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)