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

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


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. To solve the
model we call the GAMS executable with a CreateProcess call out of vba.

   Files:  Samurai.gms  samurai.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. To solve the model we call the GAMS executable with a CreateProcess call out of vba. $Offtext $call "start samurai.xls"