Have anyone ever called solver.dll

[IO HUI]

Dear all,

Hi.

This is my first time to try to call dll in LabVIEW.

I have tried to call the solver.dll in LabVIEW but I don't know what should I enter for the "Function name", "Parameter" in the configure pop-up box.

Does anyone have the experiance on calling the solver.dll of excel and can give some demo example?

Thanks in advance,

IO

[Mathan]

Hai,

---

Does anyone have the experiance on calling the solver.dll of excel and can give some demo example?

What you want to implement with that dll? Please give bit more specific detail.

Thanks,

Mathan

[smercurio_fc]

Solver is an Excel add-in, and as such is used through Excel. It doesn't expose much to the outside world. In fact, there is virtually no documentation on calling it from other programming languages. You will need to use it through Excel. As far as I can tell, this means that if you're trying to use it from LabVIEW you will need to control Excel via ActiveX in order to access Solver.

[IO HUI]

Thanks for your reply.

Yes.Solver is a add-in function in excel.

If I use ActiveX to make the connection between excel and LabVIEW, that means the whole process would depends on the Microsoft excel.

Instead of that, is there have some standalone solutions that can perform the solver function in LabVIEW?

Or  is it better to use Mathlab or Mathscript to perform the solver function in LabVIEW?Does anyone have ever used this method and can provide some suggestions or comment or demo code for that?

Thanks in advance.

Io  

[smercurio_fc]

Depends on what exactly you're trying to accomplish, which you still haven't explained. In other words, what are you trying to solve?

[IO HUI]

Thanks for your reply.

Actually I would like to solve this  Min[SQRT{SUMSQ(ai/b+ci*x+di*y-x*y)}] where a,b,c,d is the known values, i={0,1,2,3.....infinitive},

x and y values are the variables that want to find.

This is what I want to do with the solver.

Thanks in advance,

Io

[Eriquito]

Why not just code it in LabVIEW itself?  The MathScript and MATLAB© nodes are both viable options as well, but it does seem like calling that particular DLL will be especially difficult if not impossible given the current documentation.

[IO HUI]

Hi!

Thanks for your reply.

Actually using MathScript and Mathlab is my second choice for the application but I found that using MathScript would make the program run slower. Then, using Mathlab would need to install the Mathlab first.

Actually I would like teh program to run stand alone, not depends on the Excel or Mathlab or any other program.

Thanks in advance.

Io

[Mehlsack]

The command in Matlab will be:"fminsearch". It is more powerful as the EXCEL-Solver. In the other hand you need Matlab, which is not cheap.

An alternative can be Scilab (www.scilab.org) which is half-freeware. It is also possible to include Scilab code into Labview.

[IO HUI]

HI!

Thanks for your reply.

I have found some useful syntax in MathScript that can help to find the mini of the optimization of the linear programming but, still , the MathScript is very slow to run the application.

http://zone.ni.com/reference/en-XX/help/371361D-01/lvtextmath/msfunc_optimization/

Thanks in advance,

Io