Naming Subscript Elements Externally

sam0287 · Post by **sam0287** » Thu Mar 11, 2010 4:13 pm

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.

Post by **Administrator** » Thu Mar 11, 2010 5:27 pm

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.