Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and Crystal Ball
Hi all
Hopefully, some savvy folks with crystal ball - vba programming skills can help me. After I run a simulation, I would like to "Extract Data", specifically the Percentiles and Statistics. I am currently using the command: cb.ExtractDataND 1, 1 (I don't understand what the parameters are) This will extract data and place it onto a worksheet, however, I'm wondering if I can code it so that it will extract the data I specifically want. Currently, it will pull whichever data has been previously set by the user in the Excel view (i.e. The user clicks the "Extra Data" icon on the Crystal Ball toolbar and selected the "Statistics" radial button. So everytime, I execute the code, it will always pull the "Statistics" data.) Any help would be great! Thanks in Advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Crystal Ball | Excel Discussion (Misc queries) | |||
Bingo Ball | Excel Discussion (Misc queries) | |||
You guys are on the ball in here ... | Excel Worksheet Functions | |||
Ezcel crystal ball | Setting up and Configuration of Excel | |||
Crystal Ball CorrelationMatrix macro | Excel Programming |