Tasks Property

Returns a SharedWorkspaceTasks collection that represents the list of tasks in the current shared workspace. Read-only.

expression.Tasks()

expression    Required. An expression that returns a SharedWorkspace object.

Example

The following example lists the tasks in the current shared workspace.

        Dim swsTasks As Office.SharedWorkspaceTasks
    Set swsTasks = ActiveWorkbook.SharedWorkspace.Tasks
    MsgBox "There are " & swsTasks.Count & _
        " task(s) in the current shared workspace.", _
        vbInformation + vbOKOnly, _
        "Collection Information"
    Set swsTasks = Nothing