How do I respond to a dialogue box that appears whilst levelling

[Colin-online]

Hi,

When I level the resources in my project either mannually or
programmatically a dialogue box is displayed stating that Project can't
resolve an overallocation. There are 3 buttons; 'Skip', 'Skip All' and
'Stop'. When using the LevelNow command in a macro, how can I
programmatically respond to the dialogue box with the option I want ('Skip
All')? Also, how can I trap when this has occurred so I can highlight the
task it's occuring on? I'm using a For Each..Next loop to loop through the
tasks.

I'm using MS Project Standard 2002.

Thanks,

Colin

 

[Guidho]

As far as I know, you can't control the messages, shown during leveling,
programatically.
Also, you cannot catch which tasks cannot be leveled.
Everything is executed inside the method LevelNow, which you can't escape.

As a workaround, after leveling, you can look at the Leveling delay of
tasks, but this does not exactly do what you want. You can also look at tasks
where Finish = Constraint date. Or you can run programmatically through the
timephased data to see where overallocations could not be solved.

But non of these three methods can exactly sow you what you want, as they
miss some problems or might give you 'too much' (=false positives).

Regards,
Guidho