Footer Info

[André 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.

 

[Bob Phillips]

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

 

[Gord Dibben]

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