print file path and location in a footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to print the file path and default location in a footer on my
file but the footer does not have the icon for this command how do i get this
icon ? please
 
Your only way is to upgrade to Excel XP (2002) or above.

You can also put some code in your personal.xls and run it. The code below
puts the full path and fie name into the right footer of the activesheet
(Must be saved for the first time our their is no path!)

Sub FileNameInFooter()
Dim FName As String
FName = ActiveWorkbook.FullName
ActiveSheet.PageSetup.RightFooter = FName
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
be said:
I would like to print the file path and default location in a footer on my
file but the footer does not have the icon for this command how do i get this
icon ? please
Click to expand...
Page setup > Header/Footer instead of hitting the custom button check
the dropdown box. One of the default selections should be the path.

gls858
 
Back
Top