Applies to:
Decision Custom Runtime (DCR)
DTS Excel add-ins, releases 5.x and Up

 

How can I control @RISK or other Lumivero products through Visual Basic for Applications (VBA)?

Answer:

Using VBA with Excel Developer Kits (XDKs)

The Excel Developer Kits (XDKs) ship with the Professional and Industrial Editions of Lumivero products, including @RISK.

The XDKs are Visual Basic libraries that allow you to control @RISK and other Lumivero applications programmatically through VBA. They provide maximum control with minimal development time.

Requirements:

• The end user must purchase and install the application.

• The XDK is used within Excel and VBA.

Getting Started:

1. Open the product (for example, @RISK) in Excel.

2. Click Help » Developer Kit (XDK) » Automation Guide for an introduction.

3. For complete details on all objects, properties, and methods, see Help » Developer Kit (XDK) » XDK Reference.

 

Embedding Calculations in Custom Applications (Decision Custom Runtime – DCR)

If you need to run calculations without requiring Excel or Lumivero add-ins, Lumivero offers the Decision Custom Runtime (DCR).

The DCR includes the calculation engines from most Lumivero Excel add-ins, allowing you to:

• Build standalone applications

• Use your own user interface

• Run on computers without Excel or @RISK installed

 

Important:
Applications using the DCR are developed as part of a custom development agreement with Lumivero.

For more information:

• Visit the Custom Development page on the Lumivero website

• Or contact your Lumivero sales manager to discuss DCR licensing and development options

Summary

• Use XDKs to control @RISK and other products through VBA in Excel

• Use DCR to embed Lumivero calculation engines into custom, standalone applications

• DCR requires a custom development agreement with Lumivero