[Fwd: Calling GLPK with VBA Excel ?]

View: New views
2 Messages — Rating Filter:   Alert me  

[Fwd: Calling GLPK with VBA Excel ?]

by Andrew Makhorin :: Rate this Message:

| View Threaded | Show Only this Message

-------- Forwarded Message --------
From: Samir S <s10mir@...>
To: help-glpk@...
Subject: Calling GLPK with VBA Excel ?
Date: Fri, 11 May 2012 18:22:32 +0100

Hello all ! I succeeded to build with GLPK Lab a running model (.mod)
which collects data from an Excel file and record results on it.

But I wonder if there is any way to call and run this model straight
from Excel using VBA without using the interface of GLPK Lab.

p.s. I'm not an IT specialist

Thx,




_______________________________________________
Help-glpk mailing list
Help-glpk@...
https://lists.gnu.org/mailman/listinfo/help-glpk

Re: [Fwd: Calling GLPK with VBA Excel ?]

by xypron :: Rate this Message:

| View Threaded | Show Only this Message

Hello Samir,

your message had to be forwarded manually, because you are not subscribed to the GLPK help list, cf.
https://lists.gnu.org/mailman/listinfo/help-glpk

VBA offers command "SHELL" to call another program. You can use this to call glpsol, cf.
http://en.wikibooks.org/wiki/GLPK/Scripting_plus_MathProg#GLPSOL_and_Visual_Basic_for_Applications

Best regards

Xypron

> -------- Forwarded Message --------
> Subject: Calling GLPK with VBA Excel ?
> Date: Fri, 11 May 2012 18:22:32 +0100
>
> Hello all ! I succeeded to build with GLPK Lab a running model (.mod)
> which collects data from an Excel file and record results on it.
>
> But I wonder if there is any way to call and run this model straight
> from Excel using VBA without using the interface of GLPK Lab.
>
> p.s. I'm not an IT specialist
>
> Thx,
>
>
>
>
> _______________________________________________
> Help-glpk mailing list
> Help-glpk@...
> https://lists.gnu.org/mailman/listinfo/help-glpk

--
NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone!                                  
Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a

_______________________________________________
Help-glpk mailing list
Help-glpk@...
https://lists.gnu.org/mailman/listinfo/help-glpk