Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert File and Path in Footer

    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.

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert File and Path in Footer

    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.

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland
    Posts
    41
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Insert File and Path in Footer

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •