Hi,

Is there a way to have code check the "Solver" box VBA? FYI - I currently
need to do this manually using the following steps:

- Go to "Tools - Macros - Visual Basic Editor"
- Go to "Tools - References"
- Check the checkbox next to 'Solver' and click 'OK'

Thanks!


--
Robert

If you are writing VBA code to use Solver, simply set a reference to it
once in your project (manually, like you are doing now) and you are done.

If you mean that you need to check to see if Solver is installed on another
user's machine before you attempt to make calls to the Solver routines,
then include this line of code somewhere at the top of your code:

AddIns("Solver Add-in").Installed = True

--
Regards,
Bill Renaud


"robs3131" <(E-Mail Removed)> wrote in message
news:8B048C29-4F3E-4352-BD4E-(E-Mail Removed)...
> Hi,
>
> Is there a way to have code check the "Solver" box VBA? FYI - I
currently
> need to do this manually using the following steps:
>
> - Go to "Tools - Macros - Visual Basic Editor"
> - Go to "Tools - References"
> - Check the checkbox next to 'Solver' and click 'OK'
>
> Thanks!
>
>
> --
> Robert

Thanks Bill. Yeah, I figured out that once you check the box, it remains
checked for that spreadsheet. For some reason I was under the impression
that checking the box was specific to each computer -- similar to installing
Solver on each machine.

Thanks for your feedback.

--
Robert


"Bill Renaud" wrote:

> If you are writing VBA code to use Solver, simply set a reference to it
> once in your project (manually, like you are doing now) and you are done.
>
> If you mean that you need to check to see if Solver is installed on another
> user's machine before you attempt to make calls to the Solver routines,
> then include this line of code somewhere at the top of your code:
>
> AddIns("Solver Add-in").Installed = True
>
> --
> Regards,
> Bill Renaud
>
>
> "robs3131" <(E-Mail Removed)> wrote in message
> news:8B048C29-4F3E-4352-BD4E-(E-Mail Removed)...
> > Hi,
> >
> > Is there a way to have code check the "Solver" box VBA? FYI - I
> currently
> > need to do this manually using the following steps:
> >
> > - Go to "Tools - Macros - Visual Basic Editor"
> > - Go to "Tools - References"
> > - Check the checkbox next to 'Solver' and click 'OK'
> >
> > Thanks!
> >
> >
> > --
> > Robert
>
>
>

You may run into problems if the version of Excel, or the Office
installation directory, is different on the computers using the workbook. I
spent weeks trying to get the referencing to work out in this situation,
which was made more difficult by the security of later Office versions.
Finally I resorted to using Application.Run to call Solver, as I describe
here:

http://peltiertech.com/Excel/SolverVBA.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"robs3131" <(E-Mail Removed)> wrote in message
news6C1C070-26DE-4D38-B882-(E-Mail Removed)...
> Thanks Bill. Yeah, I figured out that once you check the box, it remains
> checked for that spreadsheet. For some reason I was under the impression
> that checking the box was specific to each computer -- similar to
> installing
> Solver on each machine.
>
> Thanks for your feedback.
>
> --
> Robert
>
>
> "Bill Renaud" wrote:
>
>> If you are writing VBA code to use Solver, simply set a reference to it
>> once in your project (manually, like you are doing now) and you are done.
>>
>> If you mean that you need to check to see if Solver is installed on
>> another
>> user's machine before you attempt to make calls to the Solver routines,
>> then include this line of code somewhere at the top of your code:
>>
>> AddIns("Solver Add-in").Installed = True
>>
>> --
>> Regards,
>> Bill Renaud
>>
>>
>> "robs3131" <(E-Mail Removed)> wrote in message
>> news:8B048C29-4F3E-4352-BD4E-(E-Mail Removed)...
>> > Hi,
>> >
>> > Is there a way to have code check the "Solver" box VBA? FYI - I
>> currently
>> > need to do this manually using the following steps:
>> >
>> > - Go to "Tools - Macros - Visual Basic Editor"
>> > - Go to "Tools - References"
>> > - Check the checkbox next to 'Solver' and click 'OK'
>> >
>> > Thanks!
>> >
>> >
>> > --
>> > Robert
>>
>>
>>

Very interesting! I don't understand how your CheckSolver function gets the
Solver installed correctly the 2nd time after temporarily uninstalling it
(and before running the Auto_open macro). Why wouldn't Solver simply go
back to the same state that it had when you checked
Application.AddIns("Solver Add-In").Installed the 1st time?

--
Regards,
Bill Renaud

Because it doesn't. <g>

It probably seems flip, but this protocol was developed through hours of
frustration.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bill Renaud" <(E-Mail Removed)> wrote in message
news:L_WdnRpIJJaV1pfanZ2dnUVZ_h-(E-Mail Removed)...
> Very interesting! I don't understand how your CheckSolver function gets
> the
> Solver installed correctly the 2nd time after temporarily uninstalling it
> (and before running the Auto_open macro). Why wouldn't Solver simply go
> back to the same state that it had when you checked
> Application.AddIns("Solver Add-In").Installed the 1st time?
>
> --
> Regards,
> Bill Renaud
>
>
>