how do i display the "path" and filename in the Footer?

S

sokevin

i know i can do =cell("filename")


but i want to do this in the footer.

how do i go about this?


thanks :
 
G

Gord Dibben

sokevin

If using XL2002 or newer you can enter the path and filename in the footer by
going to View>Headers and Footers and "Custom"

If earlier version of Excel you need a macro.

Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName & " " & _
ActiveSheet.Name & " " & Application.UserName & " " & Date
End Sub

Strip out what you don't want from this code.

Gord Dibben Excel MVP
 
Top