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: [email protected] [mailto:[email protected]] On Behalf Of Chang, Shih-yuan Sent: Wednesday, April 01, 2009 5:54 AM To: [email protected] 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 [email protected] 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. ---------------------------------------------------------------------------- _______________________________________________ Help-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-glpk
