RS Linx To Excel

Donnchadh · Jan 2, 2010

Hi All

I have set up a OPC server in RS LINX OEM to connected to a
excel spreed sheet. This works fine and I have no problem reading tags from my CLX processor.
The question I have is can I write down to the plc tags.
I would like to be able to read the tag and maybe change the value in the tag.

Thanks for any help
Happy new year to all.

Donnchadh

OkiePC · Jan 2, 2010

Yes. You can use DDEPoke in VBA to write values to the PLC.

There is an example in the RSLinx help files:

Code:

Sub Block_Write()

'open dde link: testsol=DDE Topic change this to YOUR topic name
 
RSIchan = DDEInitiate("RSLinx", "testsol")
 
'write data thru channel
 
DDEPoke RSIchan, "N7:30,L5", Range("[RSLINXXL.XLS]DDE_Sheet!B7:B11")
 
'close dde link
 
DDETerminate (RSIchan)
 

End Sub

Then you need an event to call the subroutine, like a command button or whatever you want.

Donnchadh · Jan 3, 2010

Hi OkiePC

Thanks for that.I palyed around with that today and it works
fine.I just used a command button and its perfect.

Thanks again

Donnchadh

wassim.daoud · Jan 4, 2010

Hello,

you can also use the this product:
http://www.matrikonanalytics.com/products/excelreporter.aspx

It's very easy to use and it has many features such as: scheduled reports, logging and many others

Hope that was helpful

Wassim Daoud
Global Solutions Architect
www.MatrikonOPC.com

RS Linx To Excel

Donnchadh

Lifetime Supporting Member

OkiePC

Lifetime Supporting Member

Donnchadh

Lifetime Supporting Member

wassim.daoud

Member

Similar Topics