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.
 
A

Andrew Gaskell

Thanks Tom.
You would have to automate Excel. The user would have to >have both Excel
and solver installed.
Click to expand...

Andrew Gaskell said:
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
Click to expand...




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Top