Calling Crystal Ball Predictor from VBA

[B.Aksoy]

Based on the following description: "The Crystal Ball and CB Predictor

Developer Kits allow users to completely automate and control Crystal

Ball simulations and CB Predictor forecasts from within a VBA program

or any other language outside of Excel supporting OLE 2 automation.

The kits consist of libraries of macro commands and functions that

unlock the programmability of Crystal Ball and CB Predictor. With the

kits, users can automatically run multiple simulations to test

different sets of assumptions, integrate Crystal Ball with other

software tools, create turnkey applications that shield users from

program intricacies, and even build custom reports or automate post-

simulation analysis."


I would like to automate Crystal Ball Predictor from within the VBA. I

run the excel macro and implement the predictor wizard. When I look at

the code the macro generated and try to run that code, there is no

response. It's not working. I did check the references to the

CBCOMDevKit and CBDevKit add-ins already. Please let me know if there

are any tips anyone can give me.

 

[Mike Middleton]

B.Aksoy -

Please let me know if there are any tips anyone can give me. <

(1) Tell us which version of Excel you're using, and post the VBA code that
you've recorded.

(2) Tell us why you want to use CB Predictor. In case you can't get it to
work, someone may have suggestions for alternative approaches to solving
your problem.

- Mike
http://www.MikeMiddleton.com