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.
Specify sheet for MENU>VDF2XLS?
Re: Specify sheet for MENU>VDF2XLS?
Same for MENU>VDF2XLSX by the way
-
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
Re: Specify sheet for MENU>VDF2XLS?
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.
You could write some simple VBA in Excel to rename the sheet to whatever you need.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559