Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Document Properties - Last Saved, Author
I tried adding the following function (from another post), in order to automate documenting the last date changed/saved and the author:
'----------------------------------------------------- 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") '-________________________________________________ I entered =DocProps("last author") in a cell, but get a "name" error. Have I placed the Function in the wrong area? Add in problems? Help appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Document Properties - Last Saved, Author
Don't know where you placed the function code but it would go into the workbook
in a General Module. To create a General Module, hit ALT + F11 to open the Visual Basic Editor. Hit CRTL + R to open Project Explorer. Find your workbook/project and select it. Right-click and InsertModule. Paste the above code in there. Save the workbook and hit ALT + Q to return to your workbook. Enter the formula as you have below. Gord Dibben Excel MVP On Sat, 2 Sep 2006 19:46:59 +0100, Michael Excel Dude wrote: I tried adding the following function (from another post), in order to automate documenting the last date changed/saved and the author: '----------------------------------------------------- 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") '-________________________________________________ I entered =DocProps("last author") in a cell, but get a "name" error. Have I placed the Function in the wrong area? Add in problems? Help appreciated. Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to open an excel document saved in a temporay file | Excel Discussion (Misc queries) | |||
Document Properties sent to print when print with office applicati | Excel Discussion (Misc queries) | |||
need document properties statistics revision information | New Users to Excel | |||
How do I recover Excel document printed but not saved | Excel Discussion (Misc queries) | |||
Document not saved on macintosh | Excel Discussion (Misc queries) |