Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I posted this last week, but i'm stuck
Q: i have a work book that is being shared amongst some co-workers and i. i was curious to know if there is a way to find out who modified it last A: '----------------------------------------------------------------- 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") But i don't know how to use this function to dump the value into a cell, a1 for example, on startup....and suggestions?? -- --Chip Smith-- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Person Names Smart Tag problems | Excel Discussion (Misc queries) | |||
Rostering problem | Excel Discussion (Misc queries) | |||
Find and Replace Technique to modify stock symbols. | Excel Discussion (Misc queries) | |||
Modify Date Changes when NOT saving | Excel Discussion (Misc queries) | |||
D Sum or SumIF | Excel Worksheet Functions |