Excel template with filepath as footer

[ijes]

Is there any way I can create an Excel Template with the page set-up footer to contain the file path and name. I can only see how to get it to include the file name and not the path as well. We work in a team and people often forget to put the file paths in the footers. If I can create a template to do do this automatically it will save so much grief.

Ian

 

[Hasit]

To add the path and file name to the center or right section of the footer, change LeftFooter to either CenterFooter or RightFooter in the code. To add the information to the header, use LeftHeader, CenterHeader, or RightHeader.

Sub UpdateFooter()
ActiveSheet.PageSetup.LeftFooter =
ActiveWorkbook.FullName
End Sub


Add the above code as a macro.