Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Long Beach, California, USA
    Posts
    1,912
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert PrintDate? (Office 2003)

    Sorry, it is too late for me to think. How do I insert the "PrintDate" into an Excel sheet? In Word one inserts it as a "Field". But there is no field option in Excel. Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Insert PrintDate? (Office 2003)

    Excel doesn't have a function for this. You can use code in the Workbook_BeforePrint event in the ThisWorkbook module to enter the current data in a cell:

    Private Sub Workbook_BeforePrint(Cancel As Boolean)
    Worksheets("MySheet").Range("B1") = Date
    End Sub

    Replace MySheet with the name of the sheet and B1 with the cell where you want the date. The value of this cell will be updated each time the workbook is printed.

  3. #3
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert PrintDate? (Office 2003)

    We have the DoP (Date of Print) added into the footer of many of our documents so we know exactly how long ago it's been lying around waiting for someone to do something about it <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Below shows how it is inserted in the footer from Page Setup (in Excel 2002).
    Attached Images Attached Images
    • File Type: gif x.gif (5.4 KB, 2 views)

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Long Beach, California, USA
    Posts
    1,912
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert PrintDate? (Office 2003)

    Thanks to both of you. These are both very helpful ideas. I use PrintDate in Word all the time -- I just expected it to be something that Excel would have as well!

Posting Permissions

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