Re: Select distribution within VBA-macros - Palisade Corporation Forums

PALISADE FORUMS

Forums Home

Member List

Faq

BestFit

Re: Select distribution within VBA-macros

Thread Starter: dkiesen Started: 08-07-2006 10:47 AM Replies: 3

Palisade Corporation Forums » Products » BestFit » Re: Select distribution within VBA-macros

Printable Version

« Previous Thread

07 Aug 2006, 10:47 AM

dkiesen is not online. Last active: 8/7/2006 11:29:39 AM

dkiesen

Top 10 Posts

Joined on 08-07-2006
Posts 2

Select distribution within VBA-macros

I am trying to program a VBA-macro to automize a fitting procedure. Therefore, I would like to choose the kinds of distribution which shall be fitted to the data within this macro. However, I did not find any possibility to it so far. It always performs the fitting with the distributions selected previously as default. Does anybody know how I can change these default value(s) within a macro?

Best regards,
Dieter

07 Aug 2006, 11:01 AM

Vince

Joined on 08-26-2005
Posts 116

Re: Select distribution within VBA-macros

Dieter,

Take a look at the online @RISK 4.5 Macros manual.

You will probably need to set values in a RiskFitType variable and use RiskFitDistributions and RiskFitGetFunction.

Regards,
Vince

07 Aug 2006, 11:29 AM

dkiesen

Top 10 Posts

Joined on 08-07-2006
Posts 2

Re: Select distribution within VBA-macros

Vince,

I have already study the manuals quite detailed, but i did not find any hint for a solution to my problem there. The function you mentioned do not allow to acces the "Specify Distributions to Fit" menu. Thus, I am still looking for a possibility to change the settings of this menu from a VBA-macro.

Regards,
Dieter

12 Nov 2009, 8:37 AM

ahowe42

Joined on 01-26-2009
Istanbul, Turkey
Posts 103

Re: Select distribution within VBA-macros

DTS 5.5 allows what you want.

Andrew

J. Andrew Howe, PhD
A statistician is a device that probably turns coffee into confidence intervals. — me

Page 1 of 1 (4 items)

Palisade Corporation Forums » Products » BestFit » Re: Select distribution within VBA-macros

You can add attachments
You can post new topics
You can reply to topics
You cannot delete your posts
You can edit your posts
You cannot create polls
You can vote in polls
Forum statistics are enabled
Forum is unmoderated