• Introduction to creating and using Excel macros.
• Sending DDE commands to WinWedge from a VBA subroutine
• Launching WinWedge from Excel
• Requesting data from WinWedge using a VBA subroutine.
• Passing data from WinWedge to Excel using DDE when you have multiple Excel workbooks open simultaneously.
• More Examples of how to request data from WinWedge using a VBA subroutine.
• Requesting Data from WinWedge using VBA SetLinkOnData method
• Getting past the 40 field limit in WinWedge
• Advanced Excel Tricks - Reading large arrays of data into Excel
• Collecting data from Multiple Serial Ports Simultaneously
• Continually Polling Multiple Devices In Sequence
• Sample Workbook This Workbook contains examples to request multiple fields of data from the wedge, request data from multiple Wedges simultaneously, request a single field of data and place it  in the active cell, and several examples of how to send data out the serial port from Excel.
• Sample workbooks for specific instruments with saved WinWedge configuration files.
• Microsoft Excel Tips and Tricks

• Collecting Data Directly into a Table in an Access Database
• Collecting Data Directly into a Form in an Access Database
• Launching and Terminating the Software Wedge from Access
• Transmitting Variables Out the Serial Port from Access
• Inventory Database Example for Access 2000
• Sample Access 2000 Database This database demonstrates how to set up Access to use DDE with WinWedge. This includes, tranmsitting data out of the serial port, reading data into a table, reading data into a form and launching and terminating WinWedge.
  [Updated 4/10/2003]

 

• Send Serial Data To Minitab using DDE

• Input Serial Data To FixDMACS using DDE

 

• General WinWedge set up and Linking Serial Data from WinWedge to DDE In InTouch
• Controlling WinWedge and serial devices from InTouch

 

• Launching the Software Wedge, requesting data from the Wedge, and closing the Wedge from Matlab

 

• Launching the Software Wedge and Collecting Data to a Column in a Spreadsheet

Important:
Dynamic Data Exchange is an extremely powerful and flexible way to pass data or commands directly from one application to another however this power and flexibility does not come without a small price in additional complexity. The examples provided here should help greatly to make the process easier. One thing to consider is that there are many situations where DDE may not be required and using WinWedge in "Send Keystrokes" mode may be more suitable. Using the Wedge in "Send Keystroke" mode is much easier and much quicker to configure than using the Wedge "DDE Server" mode.

For example if you are reading data from a simple instrument like a bar code reader, electronic balance or an electronic caliper and you simply want to input a small amount of data into a spreadsheet or database, then using "Send Keystrokes" mode may be a better and much simpler approach than using DDE.

There may also be situations where it might be convenient to input data from the Wedge using "Send Keystrokes" mode and also send data out the serial port by sending DDE commands to the Wedge.

The Wedge does not have to be in DDE Server mode in order to accept and process DDE commands. You can still send DDE commands to the Wedge to have it transmit data or prompts out a serial port even when it is in "Send Keystrokes" or "Log to Disk" mode.