Vensim to Excel
Posted: Wed Jul 18, 2012 11:32 am
Hi everyone! I hope everything is going well with the Ventana community.
I should have asked this a long time ago:
St**la has a feature which creates a "persistent" link to an excel file and allows you to drive the excel file from the SD model - no programming required and very useful when making business plans (which ultimately go in excel format). I am not very good with DLL programming and wanted to find out if anyone have any ideas about creating a dynamic link such as this without too much programming? If no such way exists, what would be very helpful is if you could give me a few sample models which clearly show how a dll link is established between the two apps.
There are some excellent videos by Mohammad Jalali on creating an ODBC link with Access (hint!) - if you can think of anything for excel that would be great!
My Best,
Karan
I should have asked this a long time ago:
St**la has a feature which creates a "persistent" link to an excel file and allows you to drive the excel file from the SD model - no programming required and very useful when making business plans (which ultimately go in excel format). I am not very good with DLL programming and wanted to find out if anyone have any ideas about creating a dynamic link such as this without too much programming? If no such way exists, what would be very helpful is if you could give me a few sample models which clearly show how a dll link is established between the two apps.
There are some excellent videos by Mohammad Jalali on creating an ODBC link with Access (hint!) - if you can think of anything for excel that would be great!
My Best,
Karan