I am using Vensim PLE Plus ver 6.2 (x32) on Windows. I have had a model saved for many years and it worked fine earlier (I last tried it about a year ago).
When I run it today, I get the error "ERROR: Failed to connect to Excel to get data from <filename>.xls".
The .mdl file and the .xls file are in the same directory.
Error in "GET XLS DATA" when I run a model that previously worked fine
Re: Error in "GET XLS DATA" when I run a model that previously worked fine
I've had the same problem recently on 1 out of 3 systems. I think it may be an Excel change. Switching from GET XLS to GET DIRECT may help.
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Re: Error in "GET XLS DATA" when I run a model that previously worked fine
MANY thanks. That worked.
I had to manually replace the GET XLSes with GET DIRECTs in about a 100 places though. Is there an easy way to do that?
I had to manually replace the GET XLSes with GET DIRECTs in about a 100 places though. Is there an easy way to do that?
-
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
Re: Error in "GET XLS DATA" when I run a model that previously worked fine
If you edit the settings in vensim, there should be an option to change the protocol used in getting values from ole to direct. This makes vensim use the direct method for everything.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Re: Error in "GET XLS DATA" when I run a model that previously worked fine
You can switch to text view (View>As Text) and use the search & replace (Edit>Replace String). Or, save the model to mdl and use your favorite text editor (Notepad++ is good and free).
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
-
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
Re: Error in "GET XLS DATA" when I run a model that previously worked fine
Ps. Can you share the original model and excel file so I can test to see why OLE is not working to get the values? If not on the forum, you can email vensim@vensim.com.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Re: Error in "GET XLS DATA" when I run a model that previously worked fine
This is fixed in 8.0.6. The problem appears to be Microsoft changes for OneDrive/Sharepoint integration.
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/