Re: Running Solver Add-In through VB ?

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

From: Luqman (pearlsoft_at_cyber.net.pk)
Date: 04/05/04 

Date: Mon, 5 Apr 2004 22:54:04 +0500

You are right, I am seeking for an example of using Automation Code for
Solver in Visual Basic 6.0, do you know any web site or example, please ?

Best Regards,

Luqman

"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:u52DiPxGEHA.3940@tk2msftngp13.phx.gbl...
> The solver addin works with Excel. You would have to use automation of
> excel to use the solver addin. You can't use it directly.
>
> --
> Regards,
> Tom Ogilvy
>
> "Luqman" <pearlsoft@cyber.net.pk> wrote in message
> news:uKrSTKwGEHA.712@tk2msftngp13.phx.gbl...
> > How can I run Excel solver Add-In through Visual Basic 6.0 and pass
> > ranges/values through VB-6 ?
> >
> > Best Regards,
> >
> > Luqman
> >
> >
> >
>
>

Relevant Pages

  • Re: Calculation Operator ">" not ">=" !!
    ... built-in comparison operators to choose from: ... (choosing the constraint A>= B appears to force the built-in ... It's MS Excel 2003 add-in Solver module. ...
    (sci.math.num-analysis)
  • Re: Excel 2007 Solver Internal Error When Generating Answer Report
    ... excel 2007 solver internal error when generating answer report ... I am running Excel 2007 under Vista. ... When I try to save either an Answer Report or a Sensitivity Report, ... With the Solver dialog box closed, I ran the following vba macro. ...
    (microsoft.public.excel.misc)
  • Re: Solver problem
    ... For example, Excel 2007's example prices are 35,50,75, but this problem uses ... This will often cause an error with Excel's Solver. ... speaker cones, power supplies, electronics, laser ... The sales price per item is reduced by 5% for orders of 100 or more and ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Finding the most fitting value of "empirical variables"
    ... the simpler (e.g. using some formulas in Excel) the better. ... *linear programming*. ... then using the EXCEL Solver tool. ... Now the variable cells are a, b, and the four ...
    (sci.math)
  • RE: How to run Solver from Visual Basic?
    ... "Tom Ogilvy" wrote: ... Here is some sample Excel code to add the solver addin and crate a reference ...
    (microsoft.public.excel.programming)