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

See also: