Rockwell Automation 2755 AdaptaScan Software - Manual (Page 187)

14–2
Publication 2755-838
The DDE syntax varies between software packages. Refer to your
software instructions for the required DDE syntax. The syntax used
by Microsoft Excel is:
=Server|Topic!’Item’
Where:
Server is AS_OLP
| is the server / topic delimiter
Topic is the name of the data you want to exchange
! is the topic / item delimiter
Item specifies the node number of the data you want to exchange.
Note: If the topic name contains a space, the topic name must be
preceded and terminated by quote marks ’Topic Name’.
For example, if you wanted to have Excel show the match count of a
Reader (DeviceNet address 0) you would enter the following string
in a worksheet cell:
=AS_OLP|’MATCH COUNT’!’0’
Only one link to a topic can be made at a time. For example, you
cannot display Reader performance in more than one Excel
worksheet.
You can use DDE with the following AdaptaScan topics.
Topic Function Data Returned Example using Excel
(default address of 63 shown)
Performance Read performance data. Scanner performance as the number of
symbols decoded within a trigger period
(000 to 100)
=AS_OLP|PERFORMANCE!’63’
LEDS Read status of LEDs. LED Status where
0 = Off
1 = Yellow
2 = Green
3 = Red
4 = Undefined
5 = Flashing Yellow
6 = Flashing Green
7 = Flashing Red
=AS_OLP|LEDS!’63 1’
Labels Read label data as it is decoded Label Data =AS_OLP|LABELS!’63’
Match Counter Read match counter. Match count =AS_OLP|’MATCH COUNTER’!’63’
Package Counter Read package count. Package count =AS_OLP|’PACKAGE COUNTER’!’63’
Reset Counters Reset package / match counters. 1 = Ok, 0 = Fail =AS_OLP|’RESET COUNTERS’!’63’
Set Match Rule Write match rule to match table. 1 = Ok, 0 = Fail =AS_OLP|’MATCH RULE’!’63’
Trigger Turn trigger on. 1 = Ok, 0 = Fail =AS_OLP|TRIGGER!’63’
Trigger Off Turn trigger off. 1 = Ok, 0 = Fail =AS_OLP|’TRIGGER OFF’!’63’
DDE Syntax
AdaptaScan DDE Topics