Using Vensim within Excel

KateO · Post by **KateO** » Wed Apr 14, 2004 3:34 pm

I am hoping to run Vensim using Excel VBA. My model has time series data in Excel accessed with GET XLS DATA functions but I currently can't get the VBA code to run the model ("Problem encountered..". Is it physically possible to do this? Does anyone have any advice on the best way of managing the process in terms of .csv, .dat and/or .tab files? Many thanks, Kate

Post by **Administrator** » Thu Apr 15, 2004 8:40 am

The attached zip file contains a demo model using GET XLS DATA, GET XLS CONSTANTS and also controlling Vensim from Excel.

Is this what you are trying to do?

Tony.

PS. Let me know if the zip file downloads ok, I seem to be having a few problems with attachments.

KateO · Post by **KateO** » Thu Apr 15, 2004 12:32 pm

The zip file opens when I click on the link but it appears to be empty.

Post by **Administrator** » Thu Apr 15, 2004 1:27 pm

Here's the model.

Post by **Administrator** » Thu Apr 15, 2004 1:28 pm

Here is the excel file.

KateO · Post by **KateO** » Wed Apr 21, 2004 11:17 am

Thanks Tony.
It seems that using the DDE links results in Vensim being open and running in the background. What I'd really like to do is keep Vensim hidden throughout and the
Excel97 example in Vensim seems to be more appropriate. Going back to my original query, do you know whether
it is physically possible to do this? Or, will I have to create .tab files or similar in order to run the model using time series input data?

Thanks.

Post by **Administrator** » Wed Apr 21, 2004 11:24 am

Someone else did try this and failed. Using the Vensim DLL from Excel will not work, it would be trying to create a DDE link to itself as Excel would be the host application.

Tony