Hello Jean-Christophe, I have now installed a 64bit Excel 2010.
I observed the following: I open a new Excel, import modules lp.bas and glpk.bas, and run routine lp(). Excel crashes. I open a new Excel, import modules lp.bas and glpk.bas, I comment the lines setting the callbacks and run routine lp(). Excel successfully runs the program. I open a new Excel, import modules lp.bas and glpk.bas, I comment the lines setting the callbacks, uncomment the lines and run routine lp(). Excel successfully runs the program. I moved the callback routines from glpk.bas to lp.bas. I open a new Excel, import the modified modules lp.bas and glpk.bas, and run routine lp(). Excel successfully runs the program. I currently have no clue why this inconsistent behavior occurs. Best regards Heinrich On 03/16/2018 03:39 PM, Huber, Jean-Christophe wrote: > Dear GLPK-team, > > > > I’m using GLPK64 from VBA/Excel and wanted to define scaling options. > > In the given example for VBA (file glpk.bas in the GLPK64 zip file from > SourceForge), there is no declaration for the scaling function. > > > > I tried adding manually as defined below: > > > > /#if win64 then/ > > /Declare PtrSafe Sub glp_scale_prob Lib "C:\GLP_DLL\glpk_4_64.dll" > (ByVal lp As LongPtr, ByVal flags As Long)/ > > /#else/ > > /Declare PtrSafe Sub glp_scale_prob Lib > "C:\GLP_DLL\glpk_4_64_stdcall.dll" (ByVal lp As LongPtr, ByVal flags As > Long)/ > > /#endif/ > > > > This works well in win32, using the stdcall compilation. > > This does not work (VBA crashes at execution) when using the w64 build. > Without scaling, there is no other issue with other functions. > > > > By the way, there is also no declaration for « glp_print_sol » function > of GLPK. I could ad dit but I’m wondering why the example in GLPK.bas do > not include it. Any issue with it ? > > > > Thansk for support / advice > > Regards > > > > _______________________________________________ > Help-glpk mailing list > [email protected] > https://lists.gnu.org/mailman/listinfo/help-glpk > _______________________________________________ Help-glpk mailing list [email protected] https://lists.gnu.org/mailman/listinfo/help-glpk
