@RISK: Accessing Simulation Data in VBA Code

To call @RISK from VBA, add a reference to @RISK. Use GetSampleData to retrieve samples, or use Mean/Percentile on simulated inputs or outputs.

Title

Answer

Applies to: @RISK 5.x and Up

Accessing @RISK worksheet functions in Visual Basic

To call @RISK functions from Visual Basic, you must set up a reference from Visual Basic Editor to @RISK via Tools » References in the editor.

Use the GetSampleData method to fill an array with the simulated data.

Example:

numSamples = _

Risk.Simulation.Results.GetSimulatedOutput("MyOutput"). _

GetSampleData(sampleData, True)

This fills the VBA array sampleData with all the data from the named output, and returns the number of samples.
You can also use GetSampleData with GetSimulatedInput.

Use Mean, Percentile, or a similar property of the RiskSimulatedResult object to get the statistics of a simulated input or output

Example:

MsgBox "The mean of MyOutput is " & _

Risk.Simulation.Results.GetSimulatedOutput("MyOutput").Mean

As with the previous example, you can use this technique with GetSimulatedInput to get statistics of a simulated input.

Related Articles:

Setting References in Visual Basic

URL Name

accessing-simulation-data-in-vba-code

Related Articles