arturo_papito

My intention is create 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 good link to learn more too.