Discussion Locked

Filename and Path in Hdr/Ftr of Excel 2K

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is it possible to place the path and filename automatically into the header or footer of an Excel 2000 spreadsheet? I know that creating a custom header and footer allows for filename and sheet name but not the entire file path. I have found two functions that will work on the spreadsheet you cannot place them in the header or footer. The =INFO("directory")function returns only the path and the =CELL("filename")function will return path, filename and sheet name.

2 replies

by hugo phurst

Yes, it's not only possible but it is made easy by Microsoft with button that when clicked insert the code for the following stuff: Page_Num Of_TotPages Path Filename Tab_Name Date Time. I make a habit of creating this footer to self documant my spreadsheets. Also, I select the inserted symbols and click the text icon to overtype the font size with a smaller one not listed in the drop-down list. Ie Courrier New Point 5. Go to File menu, select Page Setup, then choose the Header/Footer Tab. Click on the long rectangular button labelled "Custom Header". The Icon Buttons should be self-explanitory. if you have any questions after trying this, email me!

by dklippert

Excel 2002 has the ability to do this, but 2000 did not.
Inserting the path, requires a tiny macro:

Sub CustomFooter()
' Place the file name and path in the footer
' for each sheet in the active workbook

For Each sht In ActiveWorkbook.Sheets
sht.PageSetup.LeftFooter = ActiveWorkbook.FullName
Next sht
End Sub

See:
http://j-walk.com/ss/excel/tips/tip22.htm
Once again, John Walkenbach to the rescue

This discussion is closed to new replies.