RE: [Help-glpk] about Vba/glpk dll

[Meketon, Marc]

I sent to you separately the DLL that I recently compiled (version 4-36)
and a MS Access database that has VBA code that calls GLPK, allows a
variety of parameters to be changed, and (for integer programs) stores
all the integer solutions that GLPK finds.

I thought that it would be useful to other readers of this newsgroup to
mention this in case they need it as well.

It also shows how to use call-back functions and implements a VBA
version of the Driebeck-Tomlin heuristic.

This is experimental code, and probably has bunch of hardwire things and
debugging code and so on.  But at least you could get a sense of how to
use GLPK in a VBA world, especially with MS Access.  It also uses MS
Access to store the model output (the various simplex iterations) as
well as the solution.

I would like to acknowledge that Xypron gave me the code for the message
handler and few other things, and helped with the changes needed to tell
the compiler not to use __stdcall  for the compare functions needed for
the qsort.

-Marc Meketon

-----Original Message-----
From: address@hidden
[mailto:address@hidden On
Behalf Of Chang, Shih-yuan
Sent: Wednesday, April 01, 2009 5:54 AM
To: address@hidden
Subject: [Help-glpk] about Vba/glpk dll

Dear Mr.Marc or Whom it may concern,

i have been looking for the interface between VBA and glpk for a long
time. 
(and i learned that there is no direct interface)

i read your article in the forum and found the two links you posted- 

http://www.informatikfuchs.de/Software/GLPK/glpkVB_Eng.htm
http://www.informatikfuchs.de/Software/GLPK/glpkVB_Eng.htm

however, those page just show some sponsor lists which doesn't solve my
problem.

so could you help me? (could you provide me the dll file i need to
connect vba and glpk?)


best regards
Rick





_______________________________________________
Help-glpk mailing list
address@hidden
http://lists.gnu.org/mailman/listinfo/help-glpk
---------------------------------------------------------------------------- 
This e-mail and any attachments may be confidential or legally privileged.  If 
you received this message in error or are not the intended recipient, you 
should destroy the e-mail message and any attachments or copies, and you are 
prohibited from retaining, distributing, disclosing or using any information 
contained herein.  Please inform us of the erroneous delivery by return e-mail. 

Thank you for your cooperation.
----------------------------------------------------------------------------