Automatically adjust the start and finish dates for new projects

You can use the Adjust Dates macro (macro: An action or a set of actions that you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.) to adjust all the start (start date: The date when a task is scheduled to begin. This date is based on the duration, calendars, and constraints of predecessor and successor tasks. A task's start date is also based on its own calendars and constraints.) and finish dates (finish date: The date that a task is scheduled to be completed. This date is based on the task's start date, duration, calendars, predecessor dates, task dependencies, and constraints.) for the tasks (task: An activity that has a beginning and an end. Project plans are made up of tasks.) in your project in relation to a new project start date. Tasks with constraints (constraint: A restriction set on the start or finish date of a task. You can specify that a task must start on or finish no later than a particular date. Constraints can be flexible [not tied to a specific date] or inflexible [tied to a specific date].) are also adjusted.

For example, you are planning a project for the current year that is similar to another project that was completed the previous year. You can copy the .mpp file from the previous year and then run the Adjust Dates macro in the copied plan to move the dates from last year to this year. The tasks will be moved to the same position in the project, but in relation to the new project start date. So a task that began two months after the project start date in the old project will be adjusted to start two months after the new project start date. The duration will remain the same, and the finish date will be adjusted accordingly.

Tasks that have been started or finished, with the actual (actual: Information that shows what has actually occurred. For example, the actual start date for a task is the day that the task actually started.) data captured in the plan (plan: A schedule of task start and finish dates and resource and cost data. A baseline plan is the original plan that you save and use to monitor progress. An interim plan is a set of dates you save during the project to compare to other interim plans.), cannot be rescheduled. Because the Adjust Dates macro reschedules tasks, you must remove all actuals from the copied plan before running the Adjust Dates macro.

Remove actuals from your project plan

  1. On the View menu, click Gantt Chart.
  2. Select all tasks in the grid.
  3. Click Task Information Button image.
  4. On the General tab, type 0 in the Percent complete box.

Run the Adjust Dates macro

  1. Click Adjust Dates Button image on the Analysis toolbar.

To display the Analysis toolbar, point to Toolbars on the View menu, and then click Analysis.

  1. Type the new date in the Enter a new project start date box, and then click OK.

 Note   If the new project start date falls on a nonworking day according to the plan's calendar, the tasks will be adjusted to start on the first available working day.

Security  Because macros can contain viruses, be careful about running them. Take the following precautions: run up-to-date antivirus software on your computer; set your macro security level to high; clear the Trust all installed add-ins and templates check box; use digital signatures; maintain a list of trusted publishers.

Applies to:
Project 2007