| View previous topic :: View next topic |
| Author |
Message |
arturo_papito
Junior
Joined: 10 Jan 2017
Posts: 1
|
 Posted: 10/01/2017 14:31 Post subject: Comunicacion RSLINX gateway in remote server Excel/VBA |
 |
|
My intention is confecționate a visual basic program with access (or excel), if possible with a Cold link (so I wake up when I need data only). See if you can orientate me about the best way and solve my doubts. I am pretty new to all this.
I have several Allan-bradley plc’s in the Ethernet network. Several PC’s with windows 8 and excel/acces in the latests versions
I have a server in the net where I have installed RSLINX gateway version. I have created a topic and I can see the PLC variables in there OK.
In rslinx commnications -> I have set the click “enable rslinx classic gateway”
I have run the OPC test client and it works OK according to some test Ihave found in google 8so OPC/DDE server is active etc)
I want to retrieve Data in My PC from the rslinx that is in that server called BCNA08. I have colleagues that know how to run the EDIT ->copyDDE/OPC link and produse a HOT LINK in excel in the same computer for other versions of rslinx (lite I believe) that they had for tests purposes.
So I try the same but of course it does not work for a PC that is nor running RSlinx. My Rslinx is in BCNA08.
How can I set a hot link (excel continuos update) and cold link (visual basic open/close communication).
Any help or suggestions will be welcomed. Any goo link to learn more too. |
|
| Back to top |
|
 |
zolly
Junior 2
Joined: 08 May 2016
Posts: 46
|
| Posted: 10/01/2017 21:52 Post subject: Re: Comunicacion RSLINX gateway in remote server Excel/VBA |
|
|
| arturo_papito wrote: | My intention is produse a visual basic program with access (or excel), if possible with a Cold link (so I wake up when I need data only). See if you can orientate me about the best way and solve my doubts. I am pretty new to all this.
I have several Allan-bradley plc’s in the Ethernet network. Several PC’s with windows 8 and excel/acces in the latests versions
I have a server in the net where I have installed RSLINX gateway version. I have created a topic and I can see the PLC variables in there OK.
In rslinx commnications -> I have set the click “enable rslinx classic gateway”
I have run the OPC test client and it works OK according to some test Ihave found in google 8so OPC/DDE server is active etc)
I want to retrieve Data in My PC from the rslinx that is in that server called BCNA08. I have colleagues that know how to run the EDIT ->copyDDE/OPC link and create a HOT LINK in excel in the same computer for other versions of rslinx (lite I believe) that they had for tests purposes.
So I try the same but of course it does not work for a PC that is nor running RSlinx. My Rslinx is in BCNA08.
How can I set a hot link (excel continuos update) and cold link (visual basic open/close communication).
Any help or suggestions will be welcomed. Any goo link to learn more too. |
http://www.plcdev.com/connecting_controllogix_excel
http://theautomationblog.com/getting-allen-bradley-plc-and-pac-data-into-excel-using-rslinx/ |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
