View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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