Calling Excel Solver from VB (not VBA) - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Calling Excel Solver from VB (not VBA)

arjunsubarjunsub Posts: 32Member

I'm developing an application in VB. One module requires the use of the Excel Solver for finding the optimal solution.

I've been able to transfer all values to an Excel worksheet from VB. How do I call the Excel Solver from VB? or rather, can this be done? If not..what other option do I have..can I use something like solver32.dll or solver.xla

Or are there any other freely available callable dlls for VB for optimization.

would really appreciate a reply..thanx
Sign In or Register to comment.