Footnote and path

[jgarcianuanes]

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]

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