Footer Info

  • Thread starter Thread starter =?iso-8859-1?Q?Andr=E9_M.?=
  • Start date Start date
?

=?iso-8859-1?Q?Andr=E9_M.?=

Hi all,

I need to have the footer of a spreadsheet i just created
display the path i.e. c:\documents\documents here\this.doc

I know i can do it in word but can't figure out how to
have it done in this spreadsheet.

Thanks

A.
 
Andre,

You need VBA. In the ThisWorkbook code module, add this code

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName
End Sub
 
Unless you have Excel 2002, which has the fullpath feature in Custom.

Note: the workbook must be saved at least once in order for it to have a path.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top