[Date Index] [Thread Index] [Author Index]

Re: Excel Link Problem

• To: mathgroup at smc.vnet.net
• Subject: [mg53182] Re: Excel Link Problem
• From: nafod40 <noneya at business.com>
• Date: Tue, 28 Dec 2004 06:30:26 -0500 (EST)
• Organization: Penn State University, Center for Academic Computing
• References: <cqefn1$kr8$1@smc.vnet.net>
• Sender: owner-wri-mathgroup at wolfram.com

actuary at mchsi.com wrote:
> Hello:
> 
> I'm working on a project that involves calculating Maximum Likelihood
> Estimates of the 6 parameters of a 2 Regime LSwitching LogNormal Model.
> 
> I developed a Mathematica program to describe the Likelihood function.
> The program produces correct values.  I verified the results by
> comparing results to values produced by another program that has been
> professionally peer reviewed.
> 
> I placed my Mathematica code into a M-Code sheet of an Excel
> spreadsheet and can successfully call the function using Excel Link.
> 
> The problem that I have is that after using Solver to correctly
> calculate a set of MLE values for a given set of starting values,
> subsequent calls produce an error.

Do you mean subsequent runs of the solver? I am asking, because each 
time the solver solves, it runs the Mathematica code many times.

   The error message reads "Argument
> Not Optional".  The message appears to be generated as a result of
> running a Visual Basic Application which confuses me since I am not
> knowingly running a VBA program.

The Mathlink for Excel product is a VBA application (or something like 
that) so that could be the source too.

Some other questions:
- Is your code in the Excel sheet itself, or are you linking to a *.m file?
- Can you manually run the function multiple times?
- Does solver hit it multiple times?