Skip to main content

​
WinWedge DDE server settings

Remember to set WinWedge up in DDE Server Mode! See the DDE Server Mode Setup Guide. DDE Application Name: Excel DDE Topic: System DDE Command: [RUN(“InsertDataOnTop”)]

​
Excel instructions

Create or edit a macro module in Excel and enter the following code in the module: (To create a new module click on Insert > Module from the Menus in the Visual Basic Editor Window.) This example is a variation of the first example (GetSingleField). It is modified to always insert the newest record at the top – thus shifting all previous records down a row.
The example above sets up WinWedge to issue a DDE command consisting of the Excel “RUN” command forcing Excel to run the subroutine “InsertDataOnTop()” after each data record is received from your serial device. The “InsertDataOnTop” subroutine performs a DDERequest to WinWedge that returns the contents of FIELD(1) to a variable named “vDat”. vDat is then converted to a string variable, sDat and then is inserted at the top of a column and moves all previous readings down in the sheet sort of like a strip chart recorder. The latest data is always in the specified with all previous readings below it scrolling down as each new reading is inputted. The example above assumes that the open workbook contains a worksheet named Sheet1.
Last modified on November 3, 2026