Hotlink Example

[tomauro]

Are there any examples of a "live" hotlink with Excel (as mentioned in the help)...using WM_DDE_REQUEST and WM_DDE_ADVISE commands? The DDE example files are "manual" in that you have to use buttons in Excel to stimulate the data transfer, run the simulation, etc. I want to be in Vensim and have an array exported to Excel at every SAVEPER automatically.

Thanks!

[Administrator]

If you want to export to Excel every time step, you will need to write an external function. There are some helper functions for you to do this, see http://www.vensim.com/documentation/ind ... ?25885.htm.

The other alternative is to run the simulation from Excel using the Vensim DLL. This way you can step forward one time step at a time and read the values you need via the DLL functions (vensim_get_data etc).

Both methods will require you to write some code though (or at least modify the existing examples).

Tony.