Re: print the date/time last edited

On Aug 14, 3:42 am, "Bob Phillips" <Bob...@xxxxxxxxxxxxx> wrote:
'-----------------------------------------------------------------
Function DocProps(prop As String)
'-----------------------------------------------------------------
   Application.Volatile
   On Error GoTo err_value
   DocProps = ActiveWorkbook.BuiltinDocumentProperties _
   (prop)
   Exit Function
err_value:
   DocProps = CVErr(xlErrValue)
End Function

and enter in a cell such as
=DocProps ("last author")
or
=DocProps ("last save time")

--
__________________________________
HTH

Bob

"Michelle" <teacher24...@xxxxxxxxx> wrote in message

news:de29caa6-96b7-4dde-9bb1-97d6187b809e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Our school district uses Excel 2007 and the secretary uses it to keep
last rosters?  Since it's the beginning of the school year, there are
constant changes in these rosters.  Is it possible to place a date/
time field that would automatically change whenever the worksheet is
edited?  We would like to be able to tell from the print-out how old/
recent the roster is.

Could you give me a little more direction? I'm not sure what I need
to do with the above code. I tried finding docprops in the function
menu but am not seeing it. I'm used to using Office on my Mac and the
Excel 2007 for Windows is very new to me. With a little more step-by-
step direction, I'm sure that I can figure it out. By the way, if I
add the "last edited" string in each tab, will it update only for that
tab or will the date change for all tabs (even those not edited)?
.

Relevant Pages

  • Re: print the date/time last edited
    ... Function DocProps(prop As String) ...    Exit Function ... =DocProps ... tab or will the date change for all tabs? ...
    (microsoft.public.excel)
  • Re: select worksheet and run macro
    ... Store the sheet codenames instead! ... with the tab names. ...   With Sheets) ... Function Get_SheetTabName(Wkb As Workbook, CodeName As String) As ...
    (microsoft.public.excel.programming)
  • Re: 11-string recuerdos- where on the bell curve?
    ...   Yes, a couple of the ornaments in the first section did not come out ... which there is not room for improvement, slurs included, but I do not ... This is my recording of Recuerdos done on six string several years ... a heavier bass? ...
    (rec.music.classical.guitar)
  • Re: Export multiple versions of a query to separate Excel files
    ... If I try to run the code I can select the folder that I want to create ... Dim qdf As DAO.QueryDef ... Dim strSQL As String, strTemp As String, strMgr As String ...
    (microsoft.public.access.externaldata)
  • Re: Using String for new List name
    ...     for line in infile: ... and aclS represents "access control list String." ... My quest, if you will, is to create a list of syslog entries, each ... Since ACL rules can be written with a range of granularity, ...
    (comp.lang.python)