Running GAMS model from a Macro in Excel

GAMS
1

I’m currently finishing a project that involves integrating GAMS end data in Excel, unfortunately I have to run GAMS manually at each iteration on the Excel Macro. Does anyone know a way to call and run a GAMS model from a MAcro in Excel? (Maybe from a C executable because I could use the command Shell to run that .exe from the Macro)

–
To view this discussion on the web visit https://groups.google.com/d/msg/gamsworld/-/TgPyrRgy2DcJ.
To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.

2

I’m currently finishing a project that involves integrating GAMS end data
in Excel, unfortunately I have to run GAMS manually at each iteration on
the Excel Macro. Does anyone know a way to call and run a GAMS model from a
MAcro in Excel?
this is possible and there are many ways.
you may find solverstudio.org helpful. there are also some userful links in gamsworld wiki pages.
(Maybe from a C executable because I could use the command
Shell to run that .exe from the Macro)
so it’s convenient for you to can all gams.exe in GAMS install dir and exchange data with MS Excel with GDX.

HTH,

Yan
Enintech, Inc.


\

3

For me the tutorial by Bruce Mccarl was really helpful!

Starting from page 686:
http://www.gams.com/dd/docs/bigdocs/gams2002/mccarlgamsuserguide.pdf

and (http://www.gams.com/mccarl/mccarlhtml/ to get the code)

Cheers
Sophie

–
To view this discussion on the web visit https://groups.google.com/d/msg/gamsworld/-/_2PxbInfrr4J.
To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.