1. Home
  2. Create Spreadsheet Using a DDE Link

Create Spreadsheet Using a DDE Link

Select menu: Spread | New | DDE Link

A Dynamic Data Exchange (DDE) server is a windows program that can provide data to other programs. Genstat can request data from a DDE server on a given Topic and Item. If the data is changed in the DDE server, Genstat can specify that the DDE server notifies it of the changes. This ability is known as a hot link. For example, Microsoft Excel is a DDE server and the available topics in Excel are sheets in open workbooks within Excel, and the DDE items are cell addresses/ranges. Genstat can create a spreadsheet from a given sheet within an open Excel file, and if you make a change to a cell in Excel, the corresponding cell within Genstat is automatically updated. Many DDE servers can also receive data, so any changes made in Genstat can be sent to the DDE server, so that it is kept synchronized with Genstat.

  1. From the menu select Spread | New | DDE Link.

The data format from a DDE link is a rectangular table, with optional column names in the first row, and no empty rows or columns in the data.

Genstat can save the DDE link information in Genstat DDE Link format (file extension “.GDE”). Opening this file using the File | Open menu will recreate a spreadsheet from the link information, containing the latest version of the data. When a spreadsheet is saved in Genstat spreadsheet format (.GSH), information about any current DDE link is saved as well. On reopening the GSH file, Genstat will prompt to offer you the opportunity to reconnect to the previous DDE server.

This menu can be also accessed through the Spread | Add | DDE Link menu item. If the spreadsheet previously contained a DDE link, then this information is filled into the dialog.

Server

This is the name of the DDE server to request data from (e.g. Excel or QPW for Quattro for Windows). The dropdown list shows the currently running DDE servers, or DDE Servers that have been specified using the Servers button. The Windows system has two DDE servers, Shell and Folders, that are always running, but these do not provide useful data to Genstat and can generally be ignored.

If the DDE server has had an executable file defined using the Servers button, then choosing this item from the list will cause Genstat to start up the DDE server. If this is Excel, then it will still need to have the required file opened. However, fully defining the file name in the Topic entry will give Genstat enough information to allow it to automatically open the file if it’s not currently loaded.

Topic

The name of the DDE topic to request data from (e.g. in Excel this is in the form [workbook name]sheet name – e.g. [Book1.xls]Sheet1 or in Quattro for Windows this is a filename – e.g. C:DataNotebook1.wb3). The dropdown list shows the current topics (if any) for the specified DDE server.

The default format for an Excel topic excludes the files directory. Thus only one DDE link to a file of the same name is available, i.e. links could not be made to both files C:Book1.XLS and C:DATABook1.XLS. If the file name is provided in full, Genstat will open the file in Excel if it is not already open.

Item

The name of the DDE Item to request data from (e.g. in Excel this is a cell range in the format Rm1Cn1:Rm2Cn2 (e.g. R3C1:R8C4) or in Quattro for Windows it is in the format Sheet:c1m1..c2m2 e.g. A:B1..E25). The dropdown button lists the current topics (if any) for the specified DDE server and topic.

For convenience, if the server is Excel, the Item format c1m1:c2m2 (e.g. B2:BZ215) is also supported.

Servers

Open the DDE Server File Locations dialog to specify the location of the executable files belonging to named DDE servers.

If selected, the DDE server will notify Genstat of any changes made to the data and the corresponding cells in the Genstat spreadsheet will be updated automatically.

Send changes back to DDE server

If selected, the DDE server will be notified of any changes made within the Genstat spreadsheet, allowing it to update its data and display.

Send/receive column names to/from DDE server

If selected, Genstat uses the first line of data from the DDE server as the column names in the spreadsheet. The Column names are then included in the data sent and/or received to/from the DDE server. The column names are only sent back if the Send Changes back to DDE server option is selected. If both hotlink and Send back are chosen, the column names are sent in both directions.

Restrict sheet to initial size

Disable the addition or deletion of rows or columns so that the spreadsheet always matches the original size of the DDE link. This option is only available when data is only being sent to the DDE server and there are no hot links.

Automatically expand item range to sheet size

When writing to Excel, Quattro or Lotus 123 for Windows, Genstat will automatically extend the Item range to take into account the spreadsheet changing in size. This option is only available when adding a link to an existing spreadsheet and there are no hot links to the DDE server.

DDE topics and item formats by server

Server Topic Item
123W Filename Sheet:c1n1..c2n2
MSACCESS Database name; QUERY query name DATA
MSACCESS Database name; TABLE table name DATA
QPW Filename Sheet:c1n1..c2n2
EXCEL [workbook name]sheet name Rm1Cn1:Rm2Cn2
MINITAB [Project.MPJ]Worksheet.MTW Cm1:Cn2 or Rm1Cn1:Rm2Cn2
SPSSWIN !DATA [First Column Last Column n1 n2]

Note that c represent column letters, whereas m and n are used for column and row numbers, respectively.

Foreign language settings

Using an English language setup for Windows, Excel can address spreadsheet cells with R1C1 notation, where R and C are the customary single-letter abbreviations for row and column. However, other language settings may result in other letters being used to specify row and column in the cell addresses. In this case, you should refer to the DDE Servers dialog (accessed via the Server button) which permits alternative settings to be specified in Genstat as well.

See also

The DDEEXPORT procedure lets you send commands and data to a DDE server within the command language.

Updated on June 20, 2019

Was this article helpful?