PC Review


Reply
Thread Tools Rate Thread

Calling Crystal Ball Predictor from VBA

 
 
B.Aksoy
Guest
Posts: n/a
 
      30th Nov 2009
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.


 
Reply With Quote
 
 
 
 
Mike Middleton
Guest
Posts: n/a
 
      30th Nov 2009
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.
>
>


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Ball ExcelMonkey Microsoft Excel Programming 1 8th Dec 2008 08:39 PM
Crystal Ball =?Utf-8?B?UG9w?= Microsoft Excel Misc 1 8th Oct 2007 05:54 PM
Ezcel crystal ball =?Utf-8?B?amlnZ3kx?= Microsoft Excel Setup 1 12th Jan 2006 10:28 AM
Crystal Ball =?Utf-8?B?QnJpYW4gS2lya3BhdHJpY2s=?= Microsoft Excel Misc 1 24th Feb 2004 03:18 AM
VBA and Crystal Ball B Munny Microsoft Excel Programming 0 21st Jan 2004 09:15 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:14 PM.