Gets the name of the user who last modified the object. Read-only.
Syntax
expression.ModifiedBy
expression A variable that represents a SharedWorkspaceFile object.
Return Value
String
Remarks
For shared workspace objects, the ModifiedBy property returns the display name stored in the Name property of the SharedWorkspaceMember object.
Example
The following example lists the files in a shared workspace site that were last modified by users other than the creator of the workspace site.
| Visual Basic for Applications
|
Dim swsFile As Office.SharedWorkspaceFile Dim swsOwner As Office.SharedWorkspaceMember Dim strMemberFiles As String Set swsOwner = ActiveWorkbook.SharedWorkspace.Members(1) For Each swsFile In ActiveWorkbook.SharedWorkspace.Files If swsFile.ModifiedBy <> swsOwner.Name Then strMemberFiles = strMemberFiles & swsFile.URL & vbCrLf End If Next MsgBox "These files were last modified by other users:" & _ vbCrLf & strMemberFiles, _ vbInformation + vbOKOnly, "Files Modified by Other Users" Set swsOwner = Nothing Set swsFile = Nothing
|
ofv
See also: