mulderm
Member
Hello,
I have make a DDE-topic in RSLinx als Unsolicited message.
In RSLogix5 have I make a program with a MSG-instruction
and when it's enabled sending N7:0, N7:1 and N7:2 to RSLinx.
In Excel I have maked this hotlink, cel A1=N7:0, cel A2=N7:1
and cel A3=N7:2 in sheet "DDE".
This works perfect.
Now I have wrote some VBA-code:
In thisworkbook:
Private Sub Workbook_Open
Worksheets("DDE").Ondata = "Start"
End Sub
In Module1:
Sub Start
msgbox Range("A1").value
End Sub
Problem:
When I start the workbook the value in the cell is #N/B
and then the procedure is broken and get a message "error 13
mismatch".
When I have Reset this the value in the cells are 0.
When I enabled the MSG in RSLogix5 I see in my MSGBOX in
Excel "0" and the new value's are seeing in the cells.
Starting again the enabled of MSG I get the old value
seeing in my MSGBOX, but I will see the new Value.
Who can help me this problem?
NB I have use Unsolicited message to reduce traffic
mulderm
I have make a DDE-topic in RSLinx als Unsolicited message.
In RSLogix5 have I make a program with a MSG-instruction
and when it's enabled sending N7:0, N7:1 and N7:2 to RSLinx.
In Excel I have maked this hotlink, cel A1=N7:0, cel A2=N7:1
and cel A3=N7:2 in sheet "DDE".
This works perfect.
Now I have wrote some VBA-code:
In thisworkbook:
Private Sub Workbook_Open
Worksheets("DDE").Ondata = "Start"
End Sub
In Module1:
Sub Start
msgbox Range("A1").value
End Sub
Problem:
When I start the workbook the value in the cell is #N/B
and then the procedure is broken and get a message "error 13
mismatch".
When I have Reset this the value in the cells are 0.
When I enabled the MSG in RSLogix5 I see in my MSGBOX in
Excel "0" and the new value's are seeing in the cells.
Starting again the enabled of MSG I get the old value
seeing in my MSGBOX, but I will see the new Value.
Who can help me this problem?
NB I have use Unsolicited message to reduce traffic
mulderm
Last edited: