Edit

SharedWorkspaceTask.Status property (Office)

  • Article

Gets or sets the status of the specified shared workspace task. Read/write.

Note

Beginning with Microsoft Office 2010, this object or member has been deprecated and should not be used.

Syntax

expression.Status

expression Required. A variable that represents a SharedWorkspaceTask object.

Remarks

The shared workspace task schema on the server can be customized. Customization of the schema may affect the task status enumeration when the Add or Save method is called. Status property values are mapped as follows:

  • Downloaded values 1 through 5 are mapped to msoSharedWorkspaceTaskStatus enumeration values 1 through 5. Schema values beyond 5 are mapped to enumeration value 1 (msoSharedWorkspaceTaskStatusInProgress).

  • Uploaded enumeration values 1 through 5 are mapped to schema values 1 through 5. If a user-specified value does not map to any value defined in the schema, the user-specified value is silently ignored and the Status property is not updated on the server.

Example

The following example displays a list of all tasks in the current shared workspace whose status is not set to Complete.

    Dim swsTask As Office.SharedWorkspaceTask 
    Dim strTaskStatus As String 
    For Each swsTask In ActiveWorkbook.SharedWorkspace.Tasks 
        If swsTask.Status <> msoSharedWorkspaceTaskStatusCompleted Then 
            strTaskStatus = strTaskStatus & swsTask.Title & vbCrLf 
        End If 
    Next 
    MsgBox "The following tasks have not been completed:" & vbCrLf & _ 
        strTaskStatus, vbInformation + vbOKOnly, "Incomplete Tasks" 
    Set swsTask = Nothing

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.