call a published DSS model via DLL from VBA code
Posted: Tue Oct 31, 2023 10:22 am
We publish our model in DSS and only check the box ‘readable by DSS’. In our application Vensim DSS is called via a DLL from VBA code.
This gives the error ‘file blocked by this application’.
Via trial-and-error we now publish by also checking the box ‘readable by runtime’. The disadvantage of this is that we loose the functionality of being able to read the specific subscript element set from the database via GET ODBC SUBSCRIPT(); before publishing we have to reload the model with specific subscript element set and than publish it. So per subscript element set we have a separate vpmx file. For only DSS this should not be the case. DSS is able to work with ‘dynamic’ subscript element sets.
In your documentation we also read that ‘runtime’ is becoming obsolete.
What can you advice us on using DSS, publish only readable by DSS and calling DSS model via DLL from VBA, so we make use of the DSS functionality?
This gives the error ‘file blocked by this application’.
Via trial-and-error we now publish by also checking the box ‘readable by runtime’. The disadvantage of this is that we loose the functionality of being able to read the specific subscript element set from the database via GET ODBC SUBSCRIPT(); before publishing we have to reload the model with specific subscript element set and than publish it. So per subscript element set we have a separate vpmx file. For only DSS this should not be the case. DSS is able to work with ‘dynamic’ subscript element sets.
In your documentation we also read that ‘runtime’ is becoming obsolete.
What can you advice us on using DSS, publish only readable by DSS and calling DSS model via DLL from VBA, so we make use of the DSS functionality?