Results 1 to 3 of 3
  1. #1
    larryb
    Guest

    Show file path on footer (2000)

    How do you show the file path in the footer? The file name is the only choice that is given.

    thanks
    larryb

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show file path on footer (2000)

    The following code, placed in the Workbook Before Print event routine will put the file path and file name into the center footer. If you don't want the file name, just remove everything after the ActiveWorkbook.Path.

    <pre>Private Sub Workbook_BeforePrint(Cancel As Boolean
    ActiveSheet.PageSetup.CenterFooter = ActiveWorkbook.Path & "" & ActiveWorkbook.Name
    End Sub
    </pre>


    You can also use ActiveWorkbook.FullName to get the path and filename.
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show file path on footer (2000)

    Hi Legare,

    Where do I go to get the print event rountine, so that I can add the code?

    Thanks Kindly,

    Kerrie

Posting Permissions

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