forum.alglib.net

Hi There,

On your Web site it announced that ALGLIB new features like Quadratic Programming (QP) solution is available for VB6/VBA platforms.
I have downloaded free version and realized that currently available for VB6/VBA is version 2.6.0.
It means that all new updates are unavailable for this platforms.

Then I try to limit my appetite and use MIN_ASA to solve my QP problem.
I see that some of announced simple Utility functions like MaxReal() and Square() can not be located.
Are they somewhere in the package?

One more question. In almost all places in your VB code where an Integer/Long constant is expected, or may be used, you entered Floating point Double type constants, like this 5#. What is the purpose of such constant use?

Thank you,

Aleksandr

Hello!

VBA version is not supported anymore, so you are right - new updates are not available for this new platform.

As for the utility functions, these can be found in ap.bas unit. Some other functions can be found in other units, so if environment complains about something being not found, just find it using full-text search in ALGLIB distribution :)

As for the constants... I vaguely remember that it is somehow connected with type conversions in VB. Do not remember much about it, because it was many years ago...

Hi Sergey,

Thank you for your prompt answer.

I am going to use Min_ASA optimization algorithm, but looking forward still may be thinking about Quadratic Programming solution.

I just found example of implementation of C++ ALGLIB Functions as DLL and their use in VB6/VBA environment:
https://newtonexcelbach.wordpress.com/2010/05/22/linking-alglib-c-to-excel-vba/

From your experience and knowledge is it feasible to do for the person having only the basic knowledge of C++?

Thank you,

Aleksandr

Article you cited performed very simple kind of interfacing between Excel and C++ - just passing forth and back matrices. Optimization is more difficult problems, and will require more coding effort, because you have to repeatedly perform quite complex communication.

It is possible, but if you have only basic knowledge of C++, you may spent a lot of time working on this project.