Tasks with 0 effort and 0 duration are converted to MIL

[Mariano Duran]

I have a macro in my MSProject that take information from
three different files (Tasks, Roles, Assignments) and
imported the information into MS Project.

The problem is that I can have tasks with 0 effort and 0
duration that are not MIL => when the macro is run that
tasks are converted to MIL without taking into account
the "Milestone" field that say "No".

I can go manually and update that row and set the
field "Milestone" to "No" and everything works as I should
expect.

Is there any workarround to avoid letting MSProject to set
the field Milestone to "No" if the duration is 0 ?

Is there any Visual Basic alternative to change those
tasks not to be a MIL ?

 

[Jan De Messemaeker]

Hi Mariano
The .milestone field is red-write
So after putting the lot to zero, set task.milestone to false
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[Mariano Duran]

Lets put an example. I have an external file of tasks that
says.
Tsk = 1 - Work = 0 - Duration = 0 - Milestone =false
Tsk = 2 - Work = 9 - Duration = 9 - Milestone = false
Tsk = 3 - Work = 0 - Duration = 0 - Milestone = true

That means that
1) The first task is a task with 0 of duration and I would
like to see it in the workplan as a task and not a
milestone.
2) The second one is a task with 9 of duration. It is a
task
3) The third one is a milestone and should need to be
displayed as a milestone

The problem is that after running a macro that imports
this data into a workplan the first task is set to a
milestone instead of a task with 0 effort. From the MS
Project help I discovered that it is because MSProject
automatically sets the field Milestone to "yes" if the
duration = 0.

After running the macro I would be able to look at this
tasks and changed manually the field Milestone from Yes to
No.
The problem is that I do not want the user to do that
manually.

Now the question is if there is any "programmatic" way to
change that field "Milestone" to false only for those task
that match the example 1).
The other alternative is that I can use any of the other
fields (like TextXX) to determine which are the tasks that
I should need to change from Milestone=Yes to Milestone=No.

Any suggestions ?