I would like to apply distributions with VBA in MSP

January 13, 2016

Q: I would like to apply distributions with VBA in MSP.

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?

A: 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.

For more information please visit: www.intaver.com
http://www.intaver.com/IntaverFrm/viewtopic.php?f=4&t=1205