Description
This example shows two different ways to specify the GAMS System Directory via VBA: 1) By using the windows registry 2) Manually Notes The GAMS model can contain several solve statements. The solution is obtained via the VBA code activation of "trace" command line parameter The VBA modules can be exported and used in other programs If the Excel Workbook is shared, then GDXXRW can be used to write the solution into the same Workbook Developed with Visual Basic for Applications 7.0, 3/8/2013. Contributor: Toni Lastusilta
Category : GAMS Data Utilities library
Main file : SpawnGAMSExcel.gms includes : trnsport.gms SpawnGAMSExcel.gms SpawnGAMS.xlsm
$title SpawnGAMS: Spawn an arbitrary GAMS model from Excel
$onText
This example shows two different ways to specify the GAMS System Directory via VBA:
1) By using the windows registry
2) Manually
Notes
The GAMS model can contain several solve statements.
The solution is obtained via the VBA code activation of "trace" command line parameter
The VBA modules can be exported and used in other programs
If the Excel Workbook is shared, then GDXXRW can be used to write the solution into the same Workbook
Developed with Visual Basic for Applications 7.0, 3/8/2013.
Contributor: Toni Lastusilta
$offText
$callTool win32.msappavail Excel
$if errorlevel 1 $abort.noError "No Excel available"
$call "start SpawnGAMS.xlsm"