Duration as a variable?

I have a group of tasks which are repeated about a hundred times. To optimize
the project I need to vary the duration of individual tasks in my work flow.

Question: Instead of manually having to change each occurence of this task,
can I make its duration into a "variable" such that I input the duration for
a specific task once and it will then be propagated through the full schedule?

Gérard
Mon Jan 14 16:45:38 CST 2008

Robert,

You can do that only with VBA programming

Gérard Ducouret

"Robert" <Robert@discussions.microsoft.com> a écrit dans le message de news:
5B6A635D-891D-4653-83D8-05C99DEDF9BF@microsoft.com...
>I have a group of tasks which are repeated about a hundred times. To
>optimize
> the project I need to vary the duration of individual tasks in my work
> flow.
>
> Question: Instead of manually having to change each occurence of this
> task,
> can I make its duration into a "variable" such that I input the duration
> for
> a specific task once and it will then be propagated through the full
> schedule?

davegb
Tue Jan 15 08:57:50 CST 2008

On Jan 14, 3:40=A0pm, Robert <Rob...@discussions.microsoft.com> wrote:
> I have a group of tasks which are repeated about a hundred times. To optim=
ize
> the project I need to vary the duration of individual tasks in my work flo=
w.
>
> Question: Instead of manually having to change each occurence of this task=
,
> can I make its duration into a "variable" such that I input the duration f=
or
> a specific task once and it will then be propagated through the full sched=
ule?

You can't do it the way you suggest, but there is another way. You can
filter for those tasks, then select them all (click on the first one
in the list, the Shift-click on the last), then click on the Task
Information icon (Std toolbar, near the center). That will bring up
the "Multiple Task Information" box. Enter the duration and click ok.

Hope this helps in your world.

huckabrew
Tue Jan 29 18:15:25 CST 2008

I have the exact same need right now, but i'm a total noob with VBA. Is
doing what you suggest something difficult that i've got no shot at without
lots of VBA knowledge, or is it something i could pick up fairly quickly once
i learn some vba basics? Have an example, perchance?

"Gérard Ducouret" wrote:

> Robert,
>
> You can do that only with VBA programming
>
> Gérard Ducouret
>
> "Robert" <Robert@discussions.microsoft.com> a écrit dans le message de news:
> 5B6A635D-891D-4653-83D8-05C99DEDF9BF@microsoft.com...
> >I have a group of tasks which are repeated about a hundred times. To
> >optimize
> > the project I need to vary the duration of individual tasks in my work
> > flow.
> >
> > Question: Instead of manually having to change each occurence of this
> > task,
> > can I make its duration into a "variable" such that I input the duration
> > for
> > a specific task once and it will then be propagated through the full
> > schedule?
>
>
>