current path in footer

Posted by Matt on January 04, 2001 12:37 PM

Hello,
I would like to include the current path and file name
in some of my documents. The filename is pretty easy,
but I'm stumped with regard to the path. Any suggestions.

Thanks,
matt

Posted by Rickey Bowers on January 04, 2001 1:18 PM

With Application.ActiveSheet
.PageSetup.LeftFooter = "&8Path: &B" & .path
End With

I think I use something like this in my BeforePrint event - works great haven't touched it in months

Welcome, Rickey