Specify sheet for MENU>VDF2XLS?

Use this forum to post Vensim related questions.
Post Reply
kleemax
Senior Member
Posts: 125
Joined: Tue Jan 26, 2016 3:50 pm
Vensim version: PRO

Specify sheet for MENU>VDF2XLS?

Post 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.
kleemax
Senior Member
Posts: 125
Joined: Tue Jan 26, 2016 3:50 pm
Vensim version: PRO

Re: Specify sheet for MENU>VDF2XLS?

Post by kleemax »

Same for MENU>VDF2XLSX by the way
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Specify sheet for MENU>VDF2XLS?

Post 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.
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
Post Reply