Insert File and Path in Footer

Topic

New Reply

How do I insert the full path and filename into a footer? I know how to use the custom footer options, I just don’t know how to get the path in there.

Reply | Quote

Replies

In the Workbook_BeforePrint event, use a statement like:

Dim strBook_Path+Name as String
strBook_Path+Name = ActiveWorkBook.fullname
ActiveSheet.PageSetup.LeftFooter = strBook_Path+Name

You can vary the “LeftFooter” statement to be any one of the six Header/Footer locations.

Reply | Quote

Check out the ADDPATH add-in on http://www.j-walk.com/ss/%5B/url%5D. I find it’s a convenient way to optionally add the file path to a header or footer.

Reply | Quote