Hello everybody !
I would like to automatically close the Excel file where I have my inputs and outputs of my GAMS model, when I launch GAMS.
At the end of the execution of GAMS, I would like the Excel file to open again, automatically.
Do you know a command that could do that ?
Thank you very much, and farewell !
Jacques
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
\
Hi to open excel sheet i use this command Execute ‘=shellExecute D:\pHD\Result_export.xlsx’;
\
EXECUTE_UNLOAD ‘D:\pHD\Result_export.gdx’;
EXECUTE ‘Gdxxrw INPUT=D:\pHD\Result_export.gdx OUTPUT=D:\pHD\Result_export.xlsx @D:\pHD\Result_export.txt’
Execute ‘=shellExecute D:\pHD\Result_export.xlsx’;
NO idea about how to close
On Wed, Jul 31, 2013 at 5:37 PM, Jacques wrote:
Hello everybody !
I would like to automatically close the Excel file where I have my inputs and outputs of my GAMS model, when I launch GAMS.
At the end of the execution of GAMS, I would like the Excel file to open again, automatically.
Do you know a command that could do that ?
Thank you very much, and farewell !
Jacques
Regards,
Owais Nooruddin
+358465700556
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
\
Have a look at xlstalk in the gdxxrw documentation. This allows you to close and save as well as open your excel files.
Cheers
Renger
Sent from my iPhone
Am 31.07.2013 um 17:38 schrieb “Owais Nooruddin” :
Hi to open excel sheet i use this command Execute ‘=shellExecute D:\pHD\Result_export.xlsx’;
EXECUTE_UNLOAD ‘D:\pHD\Result_export.gdx’;
EXECUTE ‘Gdxxrw INPUT=D:\pHD\Result_export.gdx OUTPUT=D:\pHD\Result_export.xlsx @D:\pHD\Result_export.txt’
Execute ‘=shellExecute D:\pHD\Result_export.xlsx’;
NO idea about how to close
On Wed, Jul 31, 2013 at 5:37 PM, Jacques wrote:
Hello everybody !
I would like to automatically close the Excel file where I have my inputs and outputs of my GAMS model, when I launch GAMS.
At the end of the execution of GAMS, I would like the Excel file to open again, automatically.
Do you know a command that could do that ?
Thank you very much, and farewell !
Jacques
--
To unsubscribe from this group and stop receiving emails from it, send an email to <gamsworld+unsubscribe@googlegroups.com>.
To post to this group, send email to <gamsworld@googlegroups.com>.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
–
Regards,
Owais Nooruddin
+358465700556
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
\
Look at the XLSTalk utility
–Paul
On Wed, Jul 31, 2013 at 10:37 AM, Jacques wrote:
Hello everybody !
I would like to automatically close the Excel file where I have my inputs and outputs of my GAMS model, when I launch GAMS.
At the end of the execution of GAMS, I would like the Excel file to open again, automatically.
Do you know a command that could do that ?
Thank you very much, and farewell !
Jacques
Paul van der Eijk
GAMS Development Corporation
Tel : (202) 342-0180 Fax : (202) 342-0181
Email: pvandereijk@gams.com
Web : http://www.gams.com
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
\
Thank you, it works now !
Le mercredi 31 juillet 2013 19:35:27 UTC+2, Renger van Nieuwkoop a écrit :
Have a look at xlstalk in the gdxxrw documentation. This allows you to close and save as well as open your excel files.
Cheers
Renger
Sent from my iPhone
Am 31.07.2013 um 17:38 schrieb “Owais Nooruddin” :
Hi to open excel sheet i use this command Execute '=shellExecute D:\pHD\Result_export.xlsx';
*******************************************************************************
EXECUTE_UNLOAD 'D:\pHD\Result_export.gdx';
EXECUTE 'Gdxxrw INPUT=D:\pHD\Result_export.gdx OUTPUT=D:\pHD\Result_export.xlsx @D:\pHD\Result_export.txt'
Execute '=shellExecute D:\pHD\Result_export.xlsx';
******************************************************************************
NO idea about how to close
On Wed, Jul 31, 2013 at 5:37 PM, Jacques wrote:
Hello everybody !
I would like to automatically close the Excel file where I have my inputs and outputs of my GAMS model, when I launch GAMS.
At the end of the execution of GAMS, I would like the Excel file to open again, automatically.
Do you know a command that could do that ?
Thank you very much, and farewell !
Jacques
--
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+...@googlegroups.com.
To post to this group, send email to gams...@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
--
Regards,
Owais Nooruddin
+358465700556
--
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+...@googlegroups.com.
To post to this group, send email to gams...@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
\