Full File Path

  • Thread starter Thread starter Griff
  • Start date Start date
G

Griff

Is there is a way to display the full file pat
(drive\directory\sub-directory\sub-directory\file name) in an Exce
spradsheet footer
 
Hi
Depends on your Excel version in Excel 2002+ this is an
option in the header/footer dialog within the pagesetup
dialog

Prior to this versions you'löl need VBA. Put the following
code in your workbook module (not in a standard module):
Private Sub Workbook BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In me.Worksheets
With wkSht.PageSetup
.CenterFooter = me.fullname
End With
Next wkSht
End Sub
 
Back
Top