![]() |
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! |
All times are GMT +1. The time now is 12:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com