MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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