LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chip Smith
 
Posts: n/a
Default Last person to modify

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Person Names Smart Tag problems Goowa Excel Discussion (Misc queries) 0 November 18th 05 04:50 PM
Rostering problem Hartygan Excel Discussion (Misc queries) 1 August 26th 05 05:13 AM
Find and Replace Technique to modify stock symbols. Norm75 Excel Discussion (Misc queries) 2 July 7th 05 06:49 PM
Modify Date Changes when NOT saving LoriStar Excel Discussion (Misc queries) 1 December 10th 04 12:14 AM
D Sum or SumIF Jody Excel Worksheet Functions 3 December 3rd 04 11:39 PM


All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"