Application.UpdateProject method (Project)

Article
01/19/2022

Updates progress information and reschedules work for tasks in a project.

Syntax

expression. UpdateProject( _All_, _UpdateDate_, _Action_ )

expression A variable that represents an Application object.

Parameters

Name	Required/Optional	Data type	Description
All	Optional	Boolean	True if all tasks in the active project are updated. False if only the selected tasks are updated. The default value is True.
UpdateDate	Optional	Variant	The update date to use for the specified action.
action	Optional	Integer	The action to take with the specified tasks. Can be one of the following PjProjectUpdate constants: pj0or100Percent, pj0to100Percent, or pjReschedule. The default is pj0to100Percent.

Return value

Boolean

Remarks

Running the UpdateProject method with no arguments displays the Update Project dialog box.

The UpdateProject method corresponds to the Update Project command on the PROJECT tab of the ribbon.

Example

The following example first creates a task, sets the "% Complete" field to 50 percent; and then updates the project to schedule the rest of the work for the task to start on 9/19/2012.

Sub Update_Project() 
    ViewApply Name:="Gantt Chart" 
 
    ' Create a new task 
    RowInsert 
    SetTaskField Field:="Name", Value:="TestTask-1" 
    SetTaskField Field:="Duration", Value:="2" 
    SetTaskField Field:="% Complete", Value:="50" 
 
    'Schedule the remainder of the work to start on the update date. 
    UpdateProject All:=False, UpdateDate:="9/19/2012", action:=pjReschedule 
End Sub

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.

Share via