Ondata isn't work with a DDE-Topic in Excel

Hello,

In Excel I have place in cel A1 a topic: =RSLINX|'Testsol'!'N7:0'
This works excellent, a change in N7:0 in PLC/5 change also
in cel A1.
Then I wrote the follow code in de VBA Module1:
sub Auto()
worksheets("DDE").Ondata="Start"
end sub

sub Start()
channelnum=DDEInitiate("RSLINX", "Testsol")
data1=DDERequest(channelnum, "N40:0")
DDETerminate channelnum
range("D1").value=data1
end sub

When the value in cel A1 change, nothings happens.
It looks that the Ondata event not working.
I want to use a triggerbit to run my macro.
What do I wrong?

Greetings,

mulderm

Mulderm,

Warning I don’t know anything about VBA but have messed with it and was able to get it to work.

With that said what are you trying to do?

Bob O.

Hello Bob,

Want to use a trigger bit in the PLC/5 to
running my macro in Excel.

mulderm

Hello Bob,

I found it.
I must make a workbook_open event in my THISWORKBOOK and place
the follow code:
worksheets("DDE").Ondata="Start"
Because these must run a first time.

mulderm