Rockwell Automation 2755 AdaptaScan Software - Manual (Page 192)

14–7
Publication 2755-838
Here is an example of using DDE with Microsoft Excel:
1. Configure the Reader to decode a bar code (refer to Chapter 3).
These instructions assume the Reader is assigned an address of 0.
If needed, click the Device button to open the Device dialog,
change the address, and click the Apply button.
2. Click on the minimize button to reduce the AdaptaScan
configuration software to an icon. Do not exit the software.
3. Open a Microsoft Excel worksheet.
4. Enter the following data into the cells:
Cell A1: = AS_OLP|PERFORMANCE!’0’
Cell A2: =AS_OLP|LEDS!’0 2’
Cell A3: =AS_OLP|LABELS!’0’
5. The Excel worksheet will display the corresponding data from the
Reader.
Cell A1 shows the scanner performance
Cell A2 displays the Status of LED #2 Trigger/Read
Cell A3 displays the bar code data
6. Move the bar code symbol out of the scan beam. Notice how the
data displayed in the Excel worksheet automatically updates.
Excel Example