SpawnGAMSExcel.gms : Spawn an arbitrary GAMS model from Excel

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"