Footnote and path

jgarcianuanes · Apr 17th, 2002, 01:22 PM

Is there any way you can set up a footer so that it automatically prints the path where the document has been saved, i.e. C:/My documents/Annual Report

Or is that something I have to manually type in for each document?

lenze · Apr 17th, 2002, 01:37 PM

Place this code in the Workbook module

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName
End Sub

[ This Message was edited by: lenze on 2002-04-17 12:37 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 01:22 PM	#1
jgarcianuanes New Member Join Date: Apr 2002 Location: Jessica Posts: 5	Is there any way you can set up a footer so that it automatically prints the path where the document has been saved, i.e. C:/My documents/Annual Report Or is that something I have to manually type in for each document?

Apr 17th, 2002, 01:37 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Place this code in the Workbook module Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName End Sub [ This Message was edited by: lenze on 2002-04-17 12:37 ]