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

If you are using an earlier version 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


On Thu, 10 Jul 2003 00:34:35 +0000 (UTC), "JS" wrote:


In Excel go to View - Header and Footer - Custom Footer and enter:
&[Path]&[File]