How to record macro for Solver in Excel?

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.

You need to set a reference to Solver. Check XL help for any Solver
function (such as SolverOK).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> 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.
>

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.

Have you set a reference to the solver addin? This is the usual cause for
this problem.

http://support.microsoft.com/default...b;en-us;843304
How to create Visual Basic macros by using Excel Solver in Excel 97

--
Regards,
Tom Ogilvy

"Oscar" <[email protected]> wrote in message
news:[email protected]...
> 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.

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...b;en-us;843304
> How to create Visual Basic macros by using Excel Solver in Excel 97
>
> --
> Regards,
> Tom Ogilvy
>
> "Oscar" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

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

--
Regards,
Tom Ogilvy




"Oscar" <[email protected]> wrote in message
news:[email protected]...
> 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...b;en-us;843304
> > How to create Visual Basic macros by using Excel Solver in Excel 97
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Oscar" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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.
> >
> >
> >

>> .... 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" <[email protected]> wrote in message
news:%[email protected]...
>I have never heard of that. Do you have a reference/Link?
>
> --
> Regards,
> Tom Ogilvy
>
>
>
>
> "Oscar" <[email protected]> wrote in message
> news:[email protected]...
>> 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...b;en-us;843304
>> > How to create Visual Basic macros by using Excel Solver in Excel 97
>> >
>> > --
>> > Regards,
>> > Tom Ogilvy
>> >
>> > "Oscar" <[email protected]> wrote in message
>> > news:[email protected]...
>> > > 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.
>> >
>> >
>> >
>
>

Thanks Dana. Prior to the posting to which you are responding, I did look
at the object browser and observed what you stated although I don't work
with Solver that much, so you have added quite a bit. Right after posting I
also did search these groups in Google and saw you had participated in some
threads on this issue where the conversation tended to allude to this being
a problem in the Swedish and Spanish and perhaps some other European
editions. But as with many empirical conclusions, the cause/true nature
could be misinterpreted.

--
Regards,
Tom Ogilvy


"Dana DeLouis" <[email protected]> wrote in message
news:[email protected]...
> >> .... 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" <[email protected]> wrote in message
> news:%[email protected]...
> >I have never heard of that. Do you have a reference/Link?
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> >
> >
> > "Oscar" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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...b;en-us;843304
> >> > How to create Visual Basic macros by using Excel Solver in Excel 97
> >> >
> >> > --
> >> > Regards,
> >> > Tom Ogilvy
> >> >
> >> > "Oscar" <[email protected]> wrote in message
> >> > news:[email protected]...
> >> > > 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.
> >> >
> >> >
> >> >
> >
> >
>
>