Custom Footer

[Andrew Mackenzie]

Hi, I hope someone can help.

I am trying to put a custom footer in an excel spreadsheet giving the
filename and the path but it seems that I can only put the filename without
the path. Do I have to live with this?

Thanks,

Andrew.

 

[Guest]

&[Path]&[File]

but there should already be a button for this

 

[Guest]

Try this
When you choose custom Footer make sure to click on the folder icon and not
the Excel icon.

Regards
Sam

 

[Jim May]

I use:

Sub pathinfooter()
ActiveSheet.PageSetup.RightFooter = "&08 &" & Chr(34) & _
"Times New Roman" & Chr(34) & _
ActiveWorkbook.FullName & " " & ActiveSheet.Name
End Sub

In a standard module of my Personal.xls file - Also a Custom Button on
My toolbar runs "pathinfotter" when I need it.