Progress
External Program
Interfaces
DDE Example
The following Progress procedure uses the DDE facility to build a Microsoft Excel worksheet of customer balances from the sports database and display the customer payables distribution in an Excel pie chart. It incorporates most of the code examples in the previous sections.
The visible DDE frame displays a selection list (DDE History) showing the server, topic, and item name for each exchange as it occurs. (Note the custom selection list delimiter ( | ) used in place of the default comma delimiter that appears in commands.) When you manually change the balance value in cell
r4c2
of the worksheet, Progress uses an advise link to retrieve and display the new value in the field labeledCell R4C2 (Row 4 Col B):
NOTE: For the following example to work, you must have Excel in your path or specify the full Excel pathname for the prog_name parameter when you run the WinExec procedure to start Excel. This example assumes that you have Excel in the default Microsoft Office directory.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |