MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Full path on printed footer


Posted by Mike Ballentine on January 22, 2002 2:16 AM

I would like to know how to show the full path on a footer, e.g. C:\directory name\sub-directory name\filename.xls


Posted by Bruno on January 22, 2002 5:20 AM

Hi Mike, you could use something like this :

Private Sub InsertFullName()
ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName
End Sub