Ventana software support forum

Tony:

I've just sent an email for you.

Yes, I mean startup screen.
this error:

Yes, I'm using this code. and for first time , after I run the macro Vensim first page appears and then gives the same error.

Your forum is the best forum that I've ever seen. I'm really grateful to you .
You help me so much, but finally because of software problem I can't get result.

Thank you Tony for your help.

Yes, someone installed it for me for 5 times at a day, But vendll32.dll automatically saved at "C:\Windows\System32". They selected the DLL option at each time. and don't give me this software.

In my models (not Book2), I have to run these macros and Vensim should be open: Sub StartupDDE() DDE_channel = Application.DDEInitiate("VENSIM", "System") End Sub Sub LoadVensimModel() varstr$ = "[SPECIAL>LOADMODEL|" + Cells(2, 7).Value + "]" Application.DDEEx...

Thank you Tony . I'm Sorry to bother you. I do as you said. It gives the same error. always, I have to open the Vensim program at first. if I don't open it ,I can't run any macro. I'm not hoping that my DLL works. I think I have to find a way to change the model that Tom edited for me. I can work wi...

I could try to downloading it again. I could install it.
But :

You are right. I selected the wrong option.

I try to install it but:

Thank you Tony.
The new Book2 gives the same error.

I can't select DLL option.What can I do?

I don't have the original CD of Vensim. A company have installed it on my Laptop. I'm working with Windows 7 (x64).I've just checked this path "c:\Windows\SysWOW64" but I can't see the vendll32.dll I find it on this path "C:\Windows\System32 ". I've copied it to "c:\Windows\...

I've reinstalled it several times. But I'm working with Windows7.It dosen't work on this windows

Is there any way that I will not have to use DLL?

Thank you Tony.

Dose it work with VensimPLE?

With Vensim DLL this warning appears:

Run time error 53
File not found:vendll32.dll

I think this version of Vensim, can't work whit dll.
I've already had this problem

Yes Tony.
I have Vensim DSS version 5.9b.

Your model is wonderful. I could never write like that.

I need to find a way that can change the column automatically (GET XLS CONSTANTS( '?inputs', 'sheet1', 'H6' )

Thank you Tony. The model that I sent for you was a very simple model. I'm working on a very complicated model. I'm using an optimization model "PSO" in Matlab program. this model produces for example 9 value for iter1, 9 value for iter 2 and . . . .In fact Matlab produces some time series...

Tom: After I corrected the address ('inputs?'),Vensim dosen't fail.But when I want to get value in Excel after running this macro: Sub SetConstantaAndSimulateForFirstTime() . . . End Sub The error that I send it as attachment appears in Vensim and for each of 4 column vensim uses only the data in co...

I've edited the attached file. See the new one please.

Tom and Tony; Thank you,now it works with this address ('?inputs') But I need to SETVAL like this: For i = 1 To 4 For j = 1 To 9 varstr$ = "[Simulate>SETVAL|" + Cells(5, 7 + i).Text + "=" + Cells(5 + j, 7 + i).Text + "]" Application.DDEExecute DDE_channel, varstr$ But I...

Tony;
No, It dosen't work. error: Unable to get constant values.

Dear Tom,

In Model4.mdl,I need only to change the 'c' address in the model?

GET XLS CONSTANTS( C:\desktop\Tomfid Code.Book2.xlsm', 'sheet1', 'H6' )

I can't run it.

And How can I change VBA code(Book2)?I should run this macro in Book2 :

Sub SetConstantaAndSimulateForFirstTime()
.
.
.Endsub

I sent an email for you Tony.

Thanks again.

Thank you very much Tom.I'm trying to understand it and if I still have question I'll ask you

[Edited on 12-3-2010 by ahmadi2010]

Thank you Tom, But I can't download this attachment.When I click on it,I see a web page with these content: UTF-8} c[iteration]= GET XLS CONSTANTS( '?inputs', 'sheet1', 'H6' ) ~ ~ | active c= VECTOR ELM MAP(c[i1],active iteration-1) ~ ~ | active iteration= 1 ~ [1,4,1] ~ | one hour== 1 ~ Hour ~ | . ....

Thank you Tony. And if I have to define equation2 like this: I have some constant (c26,c27,c28.......c34) if time=26 then c26*equation2 if time=27 then c27*equation2 . . . if time=34 then c34*equation2 Can you help me please? Is there any way that I'm not forced to use IF THEN ELSE for each of time ...