DDE Link

[Guest Guest_Paolo]

I'm new in the world of PLC and VBA. I need to create a DDE link between RSLinx and a VBA program in Excel. I've try to go with RSLinx example but not working here's my code: Private Sub CommandButton1_Click() Dim test As Integer RSIchan = DDEInitiate("RSLinx", "mytopic") data = DDERequest(RSIchan, "N7:0") test = data (1) DDETerminate (RSIchan) End Sub also tried: Private Sub CommandButton1_Click() RSIchan = DDEInitiate("RSLinx", "mytopic") data = DDERequest(RSIchan, "N7:0") Range("[RSLINXXL.XLS]DDE_Sheet!C7").Value = data DDETerminate (RSIchan) End Sub it seem to stop at this line RSIchan = DDEInitiate("RSLinx", "mytopic") but I'm not sure Can someone help me please?

[Guest Guest_Paolo]

That's ok i've found!!! thx!!

[Chris Elston 79]

Great! I was going to suggest downloading this example: http://forums.mrplc.com/index.php?act=Downl...&CODE=02&id=134