Re: How to record macro for Solver in Excel?

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

>> .... When I wrote SolvOk, SolvAdd, etc.
>> ... the sentences where identified by VBA.

Hi Tom. What the op is doing is bypassing Solver's Vba code, and calling
the class function directly.
I have seen a few others mention this, but I have never understood why this
would work. The vba code portion does very little processing of the input.
It does very little, and then turns around a calls it's internal functions
using the same parameters. So, I don't know?? Using SolverOk really
should work if SolvOk works.
Sometimes placing "Solver.Auto_open" at the beginning appears to help in
some situations. But all this does is delete an internal sheet, and
rebuilds that sheet with the same small amount of data. It really shouldn't
make a difference as far as I can tell.

In the vba editor, if you pull up the "Solver" Project/Library, names like
"SolvOk" are listed on the Solver4 Class module. We use the functions on
the VBA_Function module, but then again, this does nothing more that turn
around and calls functions like SolvOK.
So, I've never really understood why the difference. I just don't see it.

--
Dana DeLouis
Win XP & Office 2003


"Tom Ogilvy" <twogilvy@xxxxxxx> wrote in message
news:%23WLKUHu7FHA.3976@xxxxxxxxxxxxxxxxxxxxxxx
>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: How to record macro for Solver in Excel?
    ... When I wrote SolvOk, SolvAdd, etc. ... What the op is doing is bypassing Solver's Vba code, ... >> Tom Ogilvy ... The solution was to use Solv instead of Solver. ...
    (microsoft.public.excel.programming)
  • Re: Decode MP3 ID3v2 and WMA tag info
    ... Tom D ... >Dim oSHA As Object, oSF As Object, oItem As Object ... >Private Function Hlink(p As String) As String ... >> My web search didn't yield any vba code or freeware COM ...
    (microsoft.public.excel.programming)
  • Re: Excel 2002 Solver unexpected Error
    ... Hallo Michael, ... Das Macro selber ist nicht passwortgeschützt, ... Extras den Solver aufrufe und gleich wieder schliesse, ... Gruss Tom ...
    (microsoft.public.de.excel)
  • Re: Using Solver with multiple ranges (Excel 2003 sp2)
    ... rigth about the self-imposed errors. ... "Tom Ogilvy" wrote: ... Often annoying problems are self-imposed, ... The Solver has to iterate over two separate ranges. ...
    (microsoft.public.excel.programming)
  • Re: ...That label/1 predicates real efficiency?
    ... constraint solver. ... Then Tom Schrijvers provided a CHR implementation - generic in the sense that it allows anyone to write his/her own constraint solvers with their favourite propagation/completeness/domain/etc. ... Tom also wrote a finite domain solver (named bounds in SWI) but mostly as a proof that it can be done in SWI - not pretending to be something super duper efficient. ...
    (comp.lang.prolog)