Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
be
 
Posts: n/a
Default print file path and location in a footer

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   Report Post  
Nick Hodge
 
Posts: n/a
Default

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   Report Post  
gls858
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reflect file path (show drive letters) in Excel 2000 Alicia Excel Discussion (Misc queries) 4 January 20th 05 07:49 PM


All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"