Page 1 of 1

Specify sheet for MENU>VDF2XLS?

Posted: Tue Jul 20, 2021 10:32 am
by kleemax
The vensim documentation for MENU>VDF2XLS does not mention a possibility to specify in the command script the sheet in the xls file into which the data is to be exported. Is there a way to specify this?

By the way: there is improvement potential in this documentation as it states tabfile instead of excel file.

Re: Specify sheet for MENU>VDF2XLS?

Posted: Tue Jul 20, 2021 10:34 am
by kleemax
Same for MENU>VDF2XLSX by the way

Re: Specify sheet for MENU>VDF2XLS?

Posted: Wed Jul 21, 2021 11:31 am
by Administrator
You cannot specify the sheet name. The sheet name will be the same as the runname (or what you are exporting to).

You could write some simple VBA in Excel to rename the sheet to whatever you need.