GAMS [ Home | Support | Sales | Solvers | Documentation | Model Libraries | Search | Contact Us ]

Samurai2 : Solve a Samurai Sudoku in Excel, using the GDX and GAMSX DLL (vba API)


In this example GAMS runs only in the background. We use the vba version of the
GDX API to write a GDX file from data defined in the spreadsheet. With the
option object API we set several GAMS options from vba and solve the model using
the gamsx API out of vba.

   Files:  Samurai2.gms  samurai2.xls
$Title Samurai Sudoku in Excel $Ontext In this example GAMS runs only in the background. We use the vba version of the GDX API to write a GDX file from data defined in the spreadsheet. With the option object API we set several GAMS options from vba and solve the model using the gamsx API out of vba. $Offtext $call "start samurai2.xls"