Pathname in footer

Posted by Rich Loving on January 15, 2002 10:45 AM

I used to be able to do this:

What is the command to insert not only the file name but the path name in the footer of a workbook?

I hope I can still do this.

Thanks,

Rich

Posted by Russell Hauf on January 15, 2002 11:24 AM

I believe you need code to do this. Try this in your Workbook module:

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

Hope this helps,

Russell

p.s. Let me know if you need help putting this in your Workbook module.

Posted by tee on January 15, 2002 2:16 PM

I found an excel add-in that prints full path etc. but I can't remember the site name. If you email me (teebird@austarnet.com.au) I will forward it to you.

tee