Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Path name in custom footers (2000)

    Hi,

    Excel XP has a Path & File button in the Footer dialogue box that automatically inserts the path and file name of the active workbook. Excel 2000 doesn't have this button. Is there a way of having the program automatically insert the path and file name in Excel 2000 (short of VB programming, I mean)?

    Thanks.

    Wyley

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Path name in custom footers (2000)

    Well, one method might be to insert a hyperlink to the document (then remove the link). I'm just fooling around with that right now.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Path name in custom footers (2000)

    Why not write a macro and assign it to a button to insert your footers?

    See This Thread

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

    Re: Path name in custom footers (2000)

    Its fairly easy to do with VBA, but I don't know of a way without using it. The code below, placed in the Workbook Before Print event routine will do this:

    <pre>Private Sub Workbook_BeforePrint(Cancel As Boolean)
    ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName
    End Sub
    </pre>

    Legare Coleman

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Path name in custom footers (2000)

    After playing around with hyperlinks, I have to agree Legare's solution is way easier. Once it is set up - there is far less fuss.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  6. #6
    Star Lounger
    Join Date
    Jan 2001
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Path name in custom footers (2000)

    Belated thanks to all who replied. I'll try the VBA route.

Posting Permissions

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