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
"B.Aksoy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>