Getting footer to display full file pathway

[Marie]

Is this possible?
How do you do it?

 

[Gord Dibben]

Marie

If using XL2002, there are icons in Headers/Footers Custom section for Path
and Filename.

If you are not using XL2002 you have to use a macro to do this.

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName
End Sub

The same code could be placed into a Workbook_BeforePrint routine.

If unfamiliar with macros visit David McRitchie's website for basics.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord Dibben Excel MVP - XL97 SR2 & XL2002

 

[Jaci]

-----Original Message-----
Is this possible?
How do you do it?
.

I found an add-in program called "Addpath" at
http://www.j-walk.com/ss/excel/files/addpath.htm

It allows you to indicate where on the page you want it to
appear and in what font/size.

 

[Marie]

Thanks. I tried this but it didn't work. It showed the
file name but not the path. Came out as just path]and then
the file name. Is it something to do with being on a
network?