MathGroup Archive 2004

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

Search the Archive

Re: Excel Link Problem

  • To: mathgroup at
  • Subject: [mg53166] Re: Excel Link Problem
  • From: "Steven Shippee" <slshippee at>
  • Date: Mon, 27 Dec 2004 06:41:37 -0500 (EST)
  • References: <cqefn1$kr8$>
  • Sender: owner-wri-mathgroup at

If you do an ALT/F11 in your spreadsheet it will show you if you have any
underlying VBA code in a module that you might not have known you have.

Then just close that window normally to get out of it if you do try the

Steven Shippee

slshippee at

<actuary at> wrote in message news:cqefn1$kr8$1 at
> 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.  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.  If I close the spreadsheet and reopen
> I can then correctly use Solver one time before encountering the same
> problem.
> Any help in understanding and resolving this problem would be
> appreciated.
> Larry

  • Prev by Date: Re: Re: rotating 3D graphic by the mouse
  • Next by Date: Re: Zero testing
  • Previous by thread: Excel Link Problem
  • Next by thread: Re: Excel Link Problem