View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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