Re: How to record macro for Solver in Excel?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have never heard of that. Do you have a reference/Link?

--
Regards,
Tom Ogilvy




"Oscar" <Oscar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DA1BA86A-2B4C-46AA-8F30-254E2760BCFB@xxxxxxxxxxxxxxxx
> Tom,
>
> I continued investigating and discovered that it seems to be a known bug
in
> Excel XP. The solution was to use Solv instead of Solver. When I wrote
> SolvOk, SolvAdd, etc. the sentences where identified by VBA.
>
> Thanks and regards,
>
> Oscar
>
> "Tom Ogilvy" wrote:
>
> > Have you set a reference to the solver addin? This is the usual cause
for
> > this problem.
> >
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;843304
> > How to create Visual Basic macros by using Excel Solver in Excel 97
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Oscar" <Oscar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:7AB53BC7-1459-4B03-AA34-6EB90B1BBE98@xxxxxxxxxxxxxxxx
> > > I am having exactly the same problem. The solver works fine when run
> > > manually, but I get that error message (not a defined Sub or function)
> > when
> > > included in a Macro. I am using Office XP. I have also tried to run
this
> > same
> > > macro using Office 2000 and it works fine!!! Any ideas of where the
> > problem
> > > is in Office XP?
> > >
> > > Oscar
> > >
> > > "Samirkc" wrote:
> > >
> > > > I tried to record a macro for Solver in Excel. After recording the
> > macro, I
> > > > ran it and the message was that the "SolverOK" which is the first
word
> > in the
> > > > body is not a defined Sub or function.
> >
> >
> >


.

Relevant Pages

  • Re: invoke a function
    ... Note that Solver is an addin - not a worksheet function. ... >> Private Sub Commandbutton1_click ... >> Regards, ... >> Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Re: starting another program
    ... If you aren't using Windows 9x or Millenium, ... Regards, ... > Dim intFile As Integer ... >> Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Re: GetOpenFilename MultiSelect failure
    ... Regards, ... >> Sub Test() ... >> Tom Ogilvy ... >>> Greg ...
    (microsoft.public.excel.programming)
  • Re: starting another program
    ... > Open FileDir & FilesInPath For Input Access Read As #1 ... >> Automation help file: ... >> Regards, ... >> Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Re: Copy Destination:= Code Stops Here
    ... Regards Aussie Bob C. ... "Tom Ogilvy" wrote: ... > in one version of Excel. ... > module refers to that sheet, not the active sheet if they are different. ...
    (microsoft.public.excel.programming)