Notes Property

Microsoft Office Visual Basic

Notes Property

Returns or sets the optional notes associated with a shared workspace link. Read/write String.

expression.Notes

expression    Required. An expression that returns a SharedWorkspaceLink object.

The following example creates a list of all the shared workspace links that contain the word "building" in the Notes field.

        Dim strBuildingLinks As String
    Dim swsLink As Office.SharedWorkspaceLink
    For Each swsLink In ActiveWorkbook.SharedWorkspace.Links
        If InStr(swsLink.Notes, "building", vbTextCompare) > 0 Then
            strBuildingLinks = strBuildingLinks & swsLink.Description & vbCrLf
        End If
    Next
    MsgBox "Building Links: " & vbCrLf & strBuildingLinks, _
        vbInformation + vbOKOnly, "Building Links in Shared Workspace"