Vensim to Excel

Use this forum to post Vensim related questions.
Post Reply
karankhosla
Senior Member
Posts: 107
Joined: Wed Nov 26, 2008 6:12 am

Vensim to Excel

Post by karankhosla »

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
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Vensim to Excel

Post by tomfid »

It would take an external function to do this, which is serious programming.

A simpler approach is to write your output to an Excel-readable file (i.e. use VDF2TAB or VDF2XLS), and link your spreadsheet to that.
karankhosla
Senior Member
Posts: 107
Joined: Wed Nov 26, 2008 6:12 am

Re: Vensim to Excel

Post by karankhosla »

Thanks Tom! I presume I could try an ODBC connection from Vensim to Excel, on the lines of the Mohammed Jalili's tutorial too?
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Vensim to Excel

Post by Administrator »

You could try that. The ODBC interface is a little tricky to set up though.
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
Post Reply