SharedWorkspaceTask.Status Property

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:

• SharedWorkspaceTask Object
• SharedWorkspaceTask Object Members