show file path in Print footers

[Guest]

How do I show the full file path in the footer of a worksheet print?

 

[Nigel]

Try.....

ActiveSheet.PageSetup.LeftFooter = "&Z&F"

 

[Dave Peterson]

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).

 

[Gord Dibben]

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