Application.UpdateProject method (Project)

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


expression. UpdateProject( _All_, _UpdateDate_, _Action_ )

expression A variable that represents an Application object.


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



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.


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 
    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.