Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Ball Pop Excel Discussion (Misc queries) 1 October 8th 07 05:54 PM
Bingo Ball Nomis-MCSE Excel Discussion (Misc queries) 1 June 1st 06 11:47 PM
You guys are on the ball in here ... Spike9458 Excel Worksheet Functions 4 February 15th 06 07:24 PM
Ezcel crystal ball jiggy1 Setting up and Configuration of Excel 1 January 12th 06 10:28 AM
Crystal Ball CorrelationMatrix macro clay Excel Programming 2 January 5th 04 02:33 PM


All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"