Re: Date Formats in Headers/Footers

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 11:01:16 -0400

Use the beforeprint event to redefine the header . format the date as part
of a string that you build that will appear as you want. Then assign it to
the appropriate property of PageSetup. 

-- 
Regards,
Tom Ogilvy
"Twoo Doggs" <TwooDoggs@discussions.microsoft.com> wrote in message
news:97A2108F-13E1-469B-9688-B580E3C092D4@microsoft.com...
> How can the format of the current date be changed in an Excel Header or
Footer when printing a document from Excel?
> -- 
> Paul M

Relevant Pages

  • Re: Regular Expression - old regex module vs. re module
    ... The ReportTemplate class reads a template file or string containing a ... header and line format for multiple calls with sequence data. ... def _format: ...
    (comp.lang.python)
  • Re: File Parser
    ... you can tell it what the comment string is and give it a format to ... you can also tell it to skip a fixed number of header ... it is fast (much faster than reading line by line) and does ...
    (comp.soft-sys.matlab)
  • detail string question
    ... Is there a way to include values of a control from the detail in string ... format in a group's header? ... Customer C ... Can it be strung together to look like this and displayed in a group's header: ...
    (microsoft.public.access.reports)
  • Parsing files using textscan()
    ... identified by a particular string. ... I want the code to figure out the location of the header named 'data' ... and start scanning from the next line onwards. ...
    (comp.soft-sys.matlab)
  • Re: How can I insert BOTH a header and upper-right page numbering?
    ... WP is being able to format by using simple buttons, ... loaded the Quick Access toolbar with all the basic commands I ... A Page number isn't considered to be, in itself, a header, but a part of a header. ... The Building Block galleries can be helpful for the 'now where did I save that' question when you know you had something 'only last ...
    (microsoft.public.word.docmanagement)