| Dynamic Data Exchange |
|
Dynamic Data Exchange (DDE) is a way of transferring data between Windows programs so that when data changes in one application, it is automatically updated in another application. PicoScope for Windows acts as a DDE server by making available a number of pieces of information (Topics) which other applications (when acting as DDE clients) can request. This communication is called a DDE link.
The easiest way to set up a link is to use the clipboard. Here is a step by step guide:
1 Open an oscilloscope window and start it running
2 Select Copy as text from the Edit menu
3 Go to the client application (Eg Excel or Quattro Pro)
4 Select Paste link or Paste Special from the Edit menu
5 Click on the place in the spreadsheet where the data is to be placed
6 The oscilloscope data appears in the spreadsheet
7 The data is updated every few seconds
Another alternative is to type into a spreadsheet cell the text necessary to create a link. To do this, it is necessary to know the Application, Topic and Item which defines the data that you require. These are as follows:
| Application: | Psw
|
| Topic: | View1 for first view, View2 for second view etc
|
| Item: | Text
|
Here are some examples:
| Excel | =Psw!View1|Text
|
| Quattro Pro | @ddelink([Psw|View1]"Text")
|
There are a number of restrictions on the DDE functions available:
Graphical DDE export is not supported
Composite views do not export text so cannot be used for DDE
The Excel formula: =PLW|Current!Value supports only one cell, so is of limited use - use the Excel macro supplied with the software
Related Topics