SharedWorkspaceLink.ModifiedBy Property - PowerPoint

Gets the name of the user who last modified the object. Read-only.

Syntax

expression.ModifiedBy

expression A variable that represents a SharedWorkspaceLink 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 links in a shared workspace site that were modified by a particular users.

Visual Basic for Applications

Visual Basic for Applications
Dim swsLink As Office.SharedWorkspaceLink Dim swsOwner As Office.SharedWorkspaceMember Dim strMemberFiles As String Dim strUser As String strUser = "Nancy Davolio" Set swsOwner = ActiveWorkbook.SharedWorkspace.Members(1) For Each swsLink In ActiveWorkbook.SharedWorkspace.Links If swsLink.ModifiedBy = strUser Then strMemberlinks = strMemberlinks & swsLink.URL & vbCrLf End If Next MsgBox "These links were modified by " & _ strUser & vbCrLf & strMemberlinks, _ vbInformation + vbOKOnly, "Modified Links" Set swsOwner = Nothing Set swsLink = Nothing

 Dim swsLink As Office.SharedWorkspaceLink Dim swsOwner As Office.SharedWorkspaceMember Dim strMemberFiles As String Dim strUser As String strUser = "Nancy Davolio" Set swsOwner = ActiveWorkbook.SharedWorkspace.Members(1) For Each swsLink In ActiveWorkbook.SharedWorkspace.Links If swsLink.ModifiedBy = strUser Then strMemberlinks = strMemberlinks & swsLink.URL & vbCrLf End If Next MsgBox "These links were modified by " & _ strUser & vbCrLf & strMemberlinks, _ vbInformation + vbOKOnly, "Modified Links" Set swsOwner = Nothing Set swsLink = Nothing

ofv

See also: