Connected Property

Microsoft Office Visual Basic

Connected Property

Returns a Boolean value that indicates whether or not the active document is currently saved in and connected to a shared workspace. Read-only Boolean.

expression.Connected

expression    Required. An expression that returns a SharedWorkspace object.

Remarks

Use the Disconnect method of the SharedWorkspace object to disconnect the local copy of the active document from the shared workspace. Use the RemoveDocument method to remove the document from the shared workspace.

Example

The following example checks the Connected property to determine whether the active document is already saved in a shared workspace.

        If ActiveWorkbook.SharedWorkspace.Connected Then
        MsgBox "This document is already saved in a shared workspace."
    End If