|
| |
Contents | Index
Dynamic Data Exchange with Other Applications
Dynamic Data Exchange (DDE) allows a change in a source file to be immediately
transmitted to a receiving (dependent) file, providing the application(s)
running the files support DDE functionality, such as this software and Microsoft
Excel. The Data Editor window may serve as either a source or receiving file.
- DDE is implemented using the Paste Link option from the Edit menu, which is only available when data has been copied to the clipboard.
- The Paste Link command (ALT, E, L) is similar to the Paste command except that
a Dynamic Data Exchange (DDE) link is set up between the Data Editor and the
file that put the data into the clipboard. This allows the data to be
transferred immediately between the two files (or applications).
- The Copied Range must be the same size as the Pasted Range.
- Linked ranges cannot be overlapped; that is, a cell cannot be receiving values
from two different links simultaneously.
- Data cannot be entered or copied into a range of a data set that is receiving
information from a DDE link. If you move the current cell cursor to a cell in
such a range, the Edit box will show a description of the link in the format:
Application|Document!Range
For example if you have pasted in a range from Excel, you might see:
Excel|Sheet1!R3C2:R8C2
- When you save a data set, information about DDE is also saved. When you reopen
the data set, you will be asked if you wish to re-establish remote links. If
the source application is not running, an attempt will be made to start it so
that the links may be re-established.
All current DDE links can be viewed, opened, closed and deleted in the DDE Links dialog box .
|
