forum.alglib.net

ALGLIB forum
It is currently Thu Mar 28, 2024 2:22 pm

All times are UTC


Forum rules


1. This forum can be used for discussion of both ALGLIB-related and general numerical analysis questions
2. This forum is English-only - postings in other languages will be removed.



Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Question regarding alglib-2.6.0.vb6
PostPosted: Mon Sep 12, 2016 10:15 pm 
Offline

Joined: Sun Sep 11, 2016 7:03 pm
Posts: 2
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


Top
 Profile  
 
 Post subject: Re: Question regarding alglib-2.6.0.vb6
PostPosted: Tue Sep 13, 2016 3:11 pm 
Offline
Site Admin

Joined: Fri May 07, 2010 7:06 am
Posts: 903
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...


Top
 Profile  
 
 Post subject: Re: Question regarding alglib-2.6.0.vb6
PostPosted: Tue Sep 13, 2016 8:54 pm 
Offline

Joined: Sun Sep 11, 2016 7:03 pm
Posts: 2
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


Top
 Profile  
 
 Post subject: Re: Question regarding alglib-2.6.0.vb6
PostPosted: Thu Sep 15, 2016 10:25 am 
Offline
Site Admin

Joined: Fri May 07, 2010 7:06 am
Posts: 903
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 53 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group