Calling Crystal Ball From Visual Basic For Applications (VBA) Programs

To call Crystal Ball subroutines and functions from VBA programs, ensure that the following conditions are true:

  To create a reference to Crystal Ball from your programs:

  1. Open your VBA program.

    In Microsoft Excel, for example, select Tools, then Macro, and then Visual Basic Editor.

  2. In the menu, select Tools, then References.

  3. Look in the Available References list for CBDevKit.

    • If the reference appears in the list, check it and click OK.

    • If the reference does not appear in the list, continue with step 4.

  4. To locate and load the code module, click Browse.

  5. Browse to the main Crystal Ball installation folder, by default:

    C:\Program Files\Oracle\Crystal Ball

  6. Change Files Of Type to Excel Files (*.xls;*.xla).

  7. Double-click CBDevKit.xla.

    CBDevKit appears in the Available References list with a check in front of it.

    Note:

    If you upgraded from 2000.x (5.x) versions of the Crystal Ball Developer Kit, locate cb.xla in the Available References list and uncheck it.

  8. Click OK.

    CBDevKit appears as a project where you can access the CB module.

    Note:

    If you do not create a reference to CBDevKit.xla, Crystal Ball calls will not be accessible from your VBA program.