Using Excel Solver through an Excel object in VB6

From: jason77 (jason77_at_discussions.microsoft.com)
Date: 12/08/04 

Date: Wed, 8 Dec 2004 12:11:04 -0800

Hello

I would like to use Excel's solver add-in to do a calculation in a visual
basic 6 application. I've created an object of type excel.application in my
vb6 code, and I would now like to add a workbook, add cells and then
configure and run solver against those cells. How do I access the solver
through my object?

Thanks.

Relevant Pages

  • Re: Using Solver to Minimise the Result of Another Iterative Routi
    ... into using the Solver. ... PS I understand that Frontline's Premium Solver has the option to call VBA ... a cell, and have values passed from VBA to cells for use by f, such as the ... capabilities of Subs and UDFs? ...
    (microsoft.public.excel.programming)
  • Re: Linear Programming(solver ?)
    ... Fill each cell in Chg with 1 for now. ... (We note that Target should now show the total of all the cells in Data). ... For Solver, minimize the Target cell, by changing the Chg cells. ... we need to add Constraints to Chg cells. ...
    (microsoft.public.excel.programming)
  • Re: Linear Programming(solver ?)
    ... Fill each cell in Chg with 1 for now. ... (We note that Target should now show the total of all the cells in Data). ... For Solver, minimize the Target cell, by changing the Chg cells. ... we need to add Constraints to Chg cells. ...
    (microsoft.public.excel.programming)
  • Re: Solver Help
    ... The problem with using Solver is: there are really 3 results to ... minimize #2 (amount of scrap). ... easy to find the optimal solution manually by trial-and- ... These are cells in which you enter your requirements. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Solver Help
    ... The problem with using Solver is: there are really 3 results to ... minimize #2 (amount of scrap). ... easy to find the optimal solution manually by trial-and- ... These are cells in which you enter your requirements. ...
    (microsoft.public.excel.worksheet.functions)
Loading