OLE linking
Object Linking and Embedding (OLE) is a widely used Microsoft technology that enables objects in two applications to be hot-linked, so that changes to the object in one application cause the same changes in the other application. For example, by linking an array in Analytica to a table in a Microsoft Excel spreadsheet, any change to the array in the Analytica model is automatically reflected in the spreadsheet.
By using OLE linking, results from Analytica models can be linked into OLE compliant applica- tions like Word and Excel. Linking data can save a great deal of work because it saves you from performing repeated copy and paste operations between Analytica and other applications when- ever your model results change. Without OLE, if you copied result tables from Analytica, pasted them into a Word document, and later you tweak your model results, you would need to re-copy and re-paste all those result tables. However, if you link those tables using OLE, all the data in the Word document either updates automatically, or if you prefer, when you explicitly decide to update the data.
You can link any of the result table views (i.e., Mid, Mean, Statistics, Probability Density, Cumula- tive Probability, and Sample table views). You can link any two-dimensional slice of a multi-dimen- sional table with the regular Copy command. For result tables with more than two dimensions, you might decide to link the entire table as a series of two-dimensional tables using the Copy Table option from the Edit menu. You can also link a rectangular region of cells that are a subset of a a two-dimensional table. However, you cannot link non-table data such as the information that is contained in the Object window or Attribute panel.
Linking procedure
Steps for linking result data from your Analytica model to an external OLE-compliant application are as follows. For concreteness, we’ll assume here that the other application is Microsoft Excel.
- In the Analytica Result window, select the cells you want to link and choose Copy from the Edit menu (Control+c).
- From Excel, select the cells where you would like the Analytica data linked.
- From Excel, choose Paste Special from the Edit menu.
- The Paste Special dialog appears.
- In this box, choose the option Paste Link, select Text from the As list, and click OK. You’re done. Any changes to the source result table are propagated to the linked data in Excel.
The procedure for linking Analytica model results to other OLE-compliant applications is similar to the above steps.
Enable comment auto-refresher