Search found 6 matches

by chriswatson
Wed Jun 18, 2008 7:39 am
Forum: Vensim
Topic: Recording only a few variables in a vdf
Replies: 1
Views: 1595

Looks like that's an easy one... I've just found the wonders of savelists!
by chriswatson
Wed Jun 18, 2008 7:00 am
Forum: Vensim
Topic: Recording only a few variables in a vdf
Replies: 1
Views: 1595

Recording only a few variables in a vdf

Hi, Is there a way of only recording a few variables from a model run in a vdf file? I have set up a model that I run from Excel 200 times, each time with a different dataset. Unfortunately, the vdf files produced are 20Mb, meaning that 200 runs uses up quite a lot of disk space! I am only intereste...
by chriswatson
Thu May 15, 2008 1:39 pm
Forum: Vensim
Topic: running Vensim from Excel
Replies: 5
Views: 4161

Hi Tony,

I tried your model and it didn't work with version 5.3. However, I now have the latest version installed, and it worked perfectly! My model used to take some time getting data from Excel, and now runs immediately, and the VBA I was using works perfectly.

Thanks for your help!

Chris
by chriswatson
Thu May 15, 2008 7:02 am
Forum: Vensim
Topic: running Vensim from Excel
Replies: 5
Views: 4161

Thanks Tony, I left the model to try and open last night, and it eventually did open, but took 50 minutes! It then tried to open the Excel input file as many times as it was referenced in the model (quite a lot in this case). One potential solution I can think of is to replace the references in Vens...
by chriswatson
Wed May 14, 2008 4:20 pm
Forum: Vensim
Topic: running Vensim from Excel
Replies: 5
Views: 4161

I should probably also have said that I am using Version 5.3. I am now not sure whether it is the fact that Excel is being referenced. I created a simple model (rate in, rate out and a level) and read some data from Excel. When trying to open this model it did open! Maybe because I have a lot of var...
by chriswatson
Wed May 14, 2008 3:37 pm
Forum: Vensim
Topic: running Vensim from Excel
Replies: 5
Views: 4161

running Vensim from Excel

Hi, I have a model in Vensim that reads data from Excel using the GET XLS CONSTANTS function. I have now been asked whether I could put a button in Excel which automatically runs the model, rather than going into Vensim. I have saved the model as a vmf, and tested my code to open the vensim model us...