$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"