M
Marie
Is this possible?
How do you do it?
How do you do it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
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
J
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.
M
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?
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?