MathGroup Archive 2004

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

Search the Archive

Re: Excel Link Problem

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

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
above.

Steven Shippee

slshippee at comcast.net

<actuary at mchsi.com> wrote in message news:cqefn1$kr8$1 at smc.vnet.net...
> 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