Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 HIS "be" wrote in message ... 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 |
#3
![]() |
|||
|
|||
![]()
be wrote:
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 Page setup Header/Footer instead of hitting the custom button check the dropdown box. One of the default selections should be the path. gls858 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reflect file path (show drive letters) in Excel 2000 | Excel Discussion (Misc queries) |