B
B Munny
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!
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!