Use of Solver outside Excel, from VB6 - without using Excel.

  • Thread starter Thread starter Andrew Gaskell
  • Start date Start date
A

Andrew Gaskell

Hi All
Does anyone know if it is possible to use the functionality that
resides within the Excel Solver add-in, from within a VB6 application
- outside Excel? I know that you can call from VB6 a macro inside an
Excel workbook which will then use solver, but is it possible
*without* Excel and without having to purchase the Solver dll?

Thanks
Andrew
 
Andrew,

I don't know if it is possible, but it certainly wouldn't be legal. In any
case, it wouldn't be that hard to write a VB subroutine that would do a
search for a specific value by varying other parameters. I'm sure that a
google search or a question posted in the VB newsgroups would turn up
something in short order.

HTH,
Bernie
MS Excel MVP
 
You would have to automate Excel. The user would have to have both Excel
and solver installed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Optimization Modeling with Excel Solver 1
Solver add-in 2
Excel 2007: Help creating a macro that will run Solver? 3
solver add in / excel solver / vba 8
Using Solver in VBA for excel without cell references 1
Using Solver with VB6 Excel Object 2
Put Value From Solver In Memory 1
Referencing and loading Solver programatically - how? 11

Back
Top