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

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
 
B

Bernie Deitrick

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
 
T

Tom Ogilvy

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

solver add in / excel solver / vba 8
Using Solver with VB6 Excel Object 2
Referencing and loading Solver programatically - how? 11
Using Solver in VBA for excel without cell references 1
Put Value From Solver In Memory 1
Solver with VBA 1
Solver VBA - Defining Solver Options 5
How to replace Excel solver with some free solver codes in Excel V 2

Top