| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
show file path in Print footers
How do I show the full file path in the footer of a worksheet print?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
show file path in Print footers
Try.....
ActiveSheet.PageSetup.LeftFooter = "&Z&F" -- Cheers Nigel "Heather" wrote in message ... How do I show the full file path in the footer of a worksheet print? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
show file path in Print footers
John Walkenbach has an addin you may like. It works with earlier versions of
excel: http://j-walk.com/ss/excel/files/addpath.htm Nigel's response will work with xl2002+ (IIRC). Heather wrote: How do I show the full file path in the footer of a worksheet print? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
show file path in Print footers
Or just use a macro like so..
Sub PathInFooter() ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName & " " & _ ActiveSheet.Name & " " & Application.UserName & " " & Date End Sub Gord Dibben Excel MVP On Fri, 01 Apr 2005 17:51:26 -0600, Dave Peterson wrote: John Walkenbach has an addin you may like. It works with earlier versions of excel: http://j-walk.com/ss/excel/files/addpath.htm Nigel's response will work with xl2002+ (IIRC). Heather wrote: How do I show the full file path in the footer of a worksheet print? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get Office 2007 to show me the full path of a file? | New Users to Excel | |||
| Show Path name for a file | Excel Discussion (Misc queries) | |||
| How to show file path in formual bar when linking workbooks? | Excel Discussion (Misc queries) | |||
| Excel file and path Footers | Excel Discussion (Misc queries) | |||
| Print file path | Excel Discussion (Misc queries) | |||
Linear Mode
