Naming Subscript Elements Externally

Use this forum to post Vensim related questions.
Post Reply
sam0287
Newbie
Posts: 1
Joined: Thu Mar 11, 2010 4:00 pm

Naming Subscript Elements Externally

Post by sam0287 »

Hello, I've been trying to find a way to input subscript element names from an excel spreadsheet (or any other source for that matter).

I've built an Excel front end for a Vensim model using the dll functions, and if I could change the subscript element names/add or remove elements from a subscript in the Excel file in a way such that they also update in the Vensim model without me having to change them there directly then this would be a very useful option, however I'm not sure if it is possible.

So basically I'm looking for a function which would be equivalent to a 'GET XLS STRING' option or something similar (I'm aware that the process may be more complex than this). Can such a thing be done? And if so can someone point me in the right direction?

Any help would be greatly appreciated.

Thanks, Sam.
Administrator
Super Administrator
Posts: 4841
Joined: Wed Mar 05, 2003 3:10 am

Post by Administrator »

As far as I am aware you cannot do this. The subscript elements need to be defined before opening the model using a DLL.

All you can really do is display one "subscript name" on the GUI, but internally convert it into the Vensim subscript and pass that one to the DLL.

Tony.
Post Reply