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

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

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

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

"Andrew Gaskell" wrote in message
om...
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

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

You would have to automate Excel. The user would have to have both Excel
and solver installed.

--
Regards,
Tom Ogilvy

"Andrew Gaskell" wrote in message
om...
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

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

Thanks Tom.

You would have to automate Excel. The user would have to have both
Excel
and solver installed.

--
Regards,
Tom Ogilvy

"Andrew Gaskell" wrote in message
om...
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




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