Path for file

  • Thread starter Thread starter Troy
  • Start date Start date
T

Troy

I am trying to show the entire path for a file in a footer
but have had a difficult time finding information on this
in the help file. Normally it will show &[file] which only
will show the filename.

Unfortunately I don't have my Excel Book with me right
now. Can you help?
 
Hi Troy
one way: process the workbook_beforeprint event. Put the following
macro in your workbook module:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In ActiveWindow.SelectedSheets
With wkSht.PageSetup
.CenterFooter = ActiveWorkbook.FullName
End With
Next wkSht
End Sub

HTH
Frank
 
Back
Top