Search found 6 matches

by Sam001
Tue Jul 25, 2017 8:41 pm
Forum: Vensim
Topic: Unable to use GET functions that call excel in Vensim DSS 7.0
Replies: 19
Views: 6649

Re: Unable to use GET functions that call excel in Vensim DSS 7.0

Everything I have is in English. My single quote button is two to the right of the L (Mac Air keyboard).

Any ideas why Vensim would change the quote style and the pre-file extension period to zero?
by Sam001
Tue Jul 25, 2017 7:45 pm
Forum: Vensim
Topic: Unable to use GET functions that call excel in Vensim DSS 7.0
Replies: 19
Views: 6649

Re: Unable to use GET functions that call excel in Vensim DSS 7.0

PS: I am attaching the model in case that helps.
by Sam001
Tue Jul 25, 2017 7:43 pm
Forum: Vensim
Topic: Unable to use GET functions that call excel in Vensim DSS 7.0
Replies: 19
Views: 6649

Re: Unable to use GET functions that call excel in Vensim DSS 7.0

Thanks! Though the vertical, single quote seems to fix the problem for a moment, the quotes return to the slanted quote and changes the period before the file extension to a zero when I close and reopen the equation editor. This triggers the same issues as before. Is there a way to get vensim to rec...
by Sam001
Tue Jul 25, 2017 7:01 pm
Forum: Vensim
Topic: Unable to use GET functions that call excel in Vensim DSS 7.0
Replies: 19
Views: 6649

Re: Unable to use GET functions that call excel in Vensim DSS 7.0

Wow. That seems to have taken care of the error. I feel silly asking, but how do you type the vertical single quote? (I copied and pasted it from the forum to try it as a solution.)

Thank you!
by Sam001
Tue Jul 25, 2017 6:03 pm
Forum: Vensim
Topic: Unable to use GET functions that call excel in Vensim DSS 7.0
Replies: 19
Views: 6649

Re: Unable to use GET functions that call excel in Vensim DSS 7.0

Thank you for your replies. I have attached screenshots in Archive.zip of what I see. (1) I use single quotes, as per the documentation and confirmed by your messages. When I attempt to Close or Check Syntax, I get a (2) popup asking if I want to add Fleet Model Inputs to the to the model. I also ge...
by Sam001
Tue Jul 25, 2017 2:27 pm
Forum: Vensim
Topic: Unable to use GET functions that call excel in Vensim DSS 7.0
Replies: 19
Views: 6649

Unable to use GET functions that call excel in Vensim DSS 7.0

When I try to use any of the functions that call data from Excel (e.g. GET XLS CONSTANTS), Vensim asks if I want to ask if I want to add the file name (without the file extension) to the model. It is as if Vensim expects there to be variables with causal links for all function arguments as it does f...