I'm trying to run simulations using command scripts and getting the constants from excel. I found this old post while seeking solutions to my problem. I'm having similar problems, so I thought I'll continue from here.
Here is my command script:
Code: Select all
SIMULATE>RUNNAME|S01.vdf
SIMULATE>SETVAL|ExcelSheet :is: 'Sheet1'
MENU>RUN
SIMULATE>RUNNAME|S02.vdf
SIMULATE>SETVAL|ExcelSheet :is: 'Sheet2'
MENU>RUN
The command script runs change the ExcelSheet variable to 'Sheet1' and 'Sheet2' as it should. But the variable constant stays the same, that is the value from the excel Sheet1. So it seems that even though the ExcelSheet is changing, the GET XLS CONSTANTS function does not notice this change. Is there any solution to this? This way would be very convenient for me to handle simulation parameters as I could handle the parameters from excel and run the simulations using the cmd file.
And I'm using at the moment Vensim DSS 6.2.
Appreciate all the help,
Tomi