Dear My Friends
I’m an IE masters student at Iran University of Science and Technology (IUST).
As my thesis project is around providing a mathematical model - which I have written in GAMS - and is to be used by another discipline’s insiders who know nothing about
OR, GAMS and the like, I tried to use Excel VBA as a GUI provider for the model. in other words, I need that GAMS to be run in the background of Excel, get input data from spreadsheets, run the model in GAMS (Background), and then import the results into Excel.
I have found two helping files from gams.com but there were some problem customizing them for the use of mine:
1- I am familiar with VBA and GAMS but there are some modules I have no idea how to customize them for my model. maybe I have to read some more VBA resources. Do you know some?
2- In contrast with your tool I have used XLS2GMS and GMS2XLS for importing and exporting between Excel and GAMS. Does it needs to be changed to GDX utility codes for the sack of being compatible with VBA?
3- If it is possible to declare or change GAMS codes from VBA? for example scaling a big model to a little one by omitting some sets and related equations?
4- Is it necessary to work with CVS file in the procedure or the whole job ( runnning a specific GAMS model in Excel’s background) or it can be done by xls2gms tool?
My thesis is going to be used by health insider, so the Excel GUI is the best choice for this issue.
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at https://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.