G Gord Dibben Jul 8, 2003 #2 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
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
J Jaci Jul 9, 2003 #3 -----Original Message----- Is this possible? How do you do it? . Click to expand... 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.
-----Original Message----- Is this possible? How do you do it? . Click to expand... 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 Jul 9, 2003 #4 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?
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?
