+ Reply to Thread
Results 1 to 2 of 2

"Last updated" line

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    42

    "Last updated" line

    Hi,

    I haven't done VBA programming in Word before (only in Excel), so I thought maybe some of you guys could help me with this simple problem: I have a document which is updated very often by various people and thus it would be nice with a line which says when the document was updated and by whom (I guess there is some kind of function which can get the "word username" or "word initials"?). This code should either be done automatic everytime the document is saved (the best option I guess) or by hitting a "update information"-button.

    So all in all I need a line in the top of the document right below the headline like: "Last updated dd/mm/yy hh:mm by username"

    I hope I have made sense Thx in advance.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: "Last updated" line

    Word has two fields you could use for this: LASTSAVEDBY and SAVEDATE. These will, as their names imply, return the details about when a document was last saved. You could put these fields, plus some appropriate text, into the document's footer. However, these fields won't tell you anything about subsequent updates if the document is printed before being saved. If you want something that does that, you'll need to create a macro-driven event handler in the Word document template, usually Normal.dot(m). See atatched.
    Attached Files Attached Files
    Last edited by macropod; 05-26-2012 at 02:39 AM.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1