Features

Automation and VBA

Run Probistica from your own code. Repeat a study for many cases, connect it to other tools, and run your own macros during a simulation.

Run a model from VBA

A VBA macro sets the settings as workbook names, starts the run, and reads the results:

Sub RunModel()
    ThisWorkbook.Names.Add "Probistica_Trials", "=20000"
    Application.Run "ProbisticaRunHeadless"
    Debug.Print Application.Run("PROBISTICA.STATUS")
    Debug.Print Application.Run("PROBISTICA.RESULT", "Profit", "MEAN")
    Debug.Print Application.Run("PROBISTICA.RESULT", "Profit", "PERCENTILE", 0.9)
End Sub

A run from VBA shows no dialog. Other commands, for example the BI export, also have a form for VBA.

The automation object

VBA gets the Probistica automation object from Excel's COM add-ins. It gives the results, the statistics, the sample data, and graphs.

The .NET client

The release package has Probistica.Xdk.dll for developers. .NET code that runs inside Excel uses it to control Probistica. The setup does not install it.

Macros in a run

Name your macros in Settings: before or after the simulation, and before or after each trial.

A run from VBA or from other code needs the license feature "automation". Both licenses include it.