I would like to apply distributions with VBA in MSP.

[PMBOK]

I would like to be able to apply lo/hi durations programmatically through VBA; however, there appears to be a dependency with the Duration Distribution text field. ?Is there documentation on how to construct the "^" delimited formatting of the Duration Distribution text field?

[Intaver Support]

There is a description of the statistical distribution code in the documentation, see Format of distribution definition text field for RiskyProject/Microsoft Project”. One of our major clients uses VB to generate this code so it has been field tested. TaskID> estimates in minutes, Seed, statistical distribution type, number of parameters.



You can use this information to create a macro which populate these fields. Our use documentation includes exact description of distribution parameters for each statistical distribution. If you use Triangular distribution, you don't need to define any parameters.