Using Path Location in a Footer

[Excel Guru]

I want to insert the entire path of a file in my footer,
example F:/marketing/shared/project/january 2004

Thank you

 

[Excel Guru]

Like the pre 97 versions of Excel use to do.

 

[J.E. McGimpsey]

Put this in your ThisWorkbook code module (right-click on the
workbook title bar and select View Code):

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In ActiveWindow.SelectedSheets
wkSht.PageSetup.LeftFooter = ActiveWorkbook.Path
Next wkSht
End Sub

This will then update every time you print or print preview.

 

[David McRitchie]

The ability was not added to Excel until Excel 2002, more information
on in http://www.mvps.org/dmcritchie/excel/pathname.htm
particularly for versions before Excel 2002.