Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using Excel Solver | Excel Discussion (Misc queries) | |||
Solver for excel | Excel Worksheet Functions | |||
How to use Excel Solver? | Excel Discussion (Misc queries) | |||
how to use solver in excel | New Users to Excel | |||
How can I get the Solver Add-in in Excel 97? | Excel Discussion (Misc queries) |