Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple line footers (Excel 97)

    Using the BeforePrint event to add the full pathname is useful. However, in doing so the full system-wide path designation is rather lengthy. That's fine. However it bumps into the right-side time and date stamp I like to have in the footer (even when the path is located in the LeftFooter location.) I have taken a few stabs at "bumping down" the time/date lines to no avail. My question to experienced users: Can the footer line be in fact expanded? Or are we constrained to one slim line of data? To reduce the font size of the path is an obvious option, but would render the information illegible, especially after copying. Also, my preference is to avoid header time and date stamps, since the header is for more formal titles and so on.
    Thank you for your suggestions.

  2. #2
    Star Lounger
    Join Date
    Jun 2001
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple line footers (Excel 97)

    just include a CHR(10) somewhere in your setting. If you START with CHR(10), then the footer will be below other lines.
    Activesheet.pagesetup.leftfooter=chr(10) & activeworkbook.fullname

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Multiple line footers (Excel 97)

    You can have multiple line footers, just make sure you allow enough space when setting the margins !.

    In your BeforePrint routine you can use the VBA constant VbCrLf which inserts a carriage Return and Line Feed. The following code is an example :<pre>With ActiveSheet.PageSetup
    .LeftFooter = strFilePath & VbCrLf & "&D - &T"
    'further code if required
    End With</pre>

    where strFilePath is a string variable holding the path & file name.

    Andrew C

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Multiple line footers (Excel 97)

    Not clear on what you want to do; there's no reason you can't use two lines in a header or footer:

    .CenterFooter = "&8" & ActiveWorkbook.FullName & " ~&A" & Chr(10) & "
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple line footers (Excel 97)

    OK! Thanks everybody..let me work on those ideas.

Posting Permissions

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