ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Optimizing in VB (https://www.excelbanter.com/excel-programming/273953-optimizing-vbulletin.html)

Phil

Optimizing in VB
 
I would like to know if it is possible to optimize or
minimize functions with VB.
I know the 'Solver' does it in Excel, but is there a
similar fonction in VB?

Thank you

Tom Ogilvy

Optimizing in VB
 
You can call solver from VBA.

http://support.microsoft.com/support...ver/solver.asp
Creating Visual Basic Macros that Use Microsoft Excel Solver

Regards,
Tom Ogilvy


"Phil" wrote in message
...
I would like to know if it is possible to optimize or
minimize functions with VB.
I know the 'Solver' does it in Excel, but is there a
similar fonction in VB?

Thank you





All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com