Hello:
I use to work with visual basic applications. Theses DSS can be used to manage vensim models from excel. Does anybody knows how to view vensim sketches from excel?
Thank you very much
sketches from excel
-
Administrator
- Super Administrator
- Posts: 4589
- Joined: Wed Mar 05, 2003 3:10 am
It seems like it should be easy, but I cannot seem to work out a way of getting a handle to a window using VBA.
The function you need is vensim_show_sketch, the final parameter you pass to the function needs to be the hWnd of the image/frame where you want the sketch to appear.
The only problem is finding the hWnd. The MSDN website (http://msdn.microsoft.com/library/defau ... indows.asp)
says
"A Visual Basic Form object has an hWnd property we can use, but a VBA UserForm object does not include a property or method for getting at its window handle".
Does anyone else know how to get the hWnd of a control using VBA?
Tony.
The function you need is vensim_show_sketch, the final parameter you pass to the function needs to be the hWnd of the image/frame where you want the sketch to appear.
The only problem is finding the hWnd. The MSDN website (http://msdn.microsoft.com/library/defau ... indows.asp)
says
"A Visual Basic Form object has an hWnd property we can use, but a VBA UserForm object does not include a property or method for getting at its window handle".
Does anyone else know how to get the hWnd of a control using VBA?
Tony.