DueDate Property

Microsoft Office Visual Basic

DueDate Property

Returns or sets the optional due date and time of a SharedWorkspaceTask object. Read/write Variant.

expression.DueDate()

expression    Required. An expression that returns a SharedWorkspaceTask object.

Example

The following example sets the DueDate of all tasks in a shared workspace to 12:00 noon on December 31, 2005 and uploads these changes to the server using the Save method.

        Dim swsTask As Office.SharedWorkspaceTask
    Const dtmNewDueDate As Date = #12/31/2005 12:00:00 PM#
    For Each swsTask In ActiveWorkbook.SharedWorkspace.Tasks
        swsTask.DueDate = dtmNewDueDate
        swsTask.Save
    Next
    Set swsTask = Nothing