Problem setting RSLinx OPC UpdateRate with VBA

Join Date
Aug 2005
Location
Franklin Park, NJ
Posts
4
Hello everyone. Long time listener, first time caller.

I'm having a problem with RSLinx OPC in an Excel VBA application. I have posted this over on the Rockwell Software site forum, but from past experience I don't think I'll get any solutions over there. There is a much better pool of resources over here, I think.

The application is reading a stand-alone rack of Allen-Bradley Point-I/O (1734 series) over Ethernet/IP using RSLinx OEM. I'm using the OPC Automation Wrapper from Software Toolbox to access the OPC objects in VBA (why does A-B only distribute an Automation Wrapper with SDK?). Everthing is going well except that I am not able to set the Update rate for the OPC group.

The program gets the OPCGroups collection and adds a group object which I named "AIO_Group". The problem is when I set the Update Rate for the OPCGroup object (AIO_Group.UpdateRate) to say 1000, the actual rate drops to 1. I confirmed this by reading the UpdateRate property later on in the program, and by monitoring the OPC Diagnostics in RSLinx. Does anyone know of any special handling for this property?

The strange part is that if I take out the group UpdateRate statement and add one to set the OPCGroups collection object DefaultGroupUpdateRate property, it works fine. But that way I lose the ability to set individual group update rates (I want one at 2 seconds and one at 500ms).

Has anyone done this successfully with RSLinx? Thanks.

Don

 
Not sure if this will help or not.

With help over at MrPlc I was able to “HACKED” through this and pull data from an MS Access table and place it into an Excel spread sheet that then sent it to my ML1500 every 5 sec using a hotlink . If you like I can post what I have and you can take a look.
 
Thanks for the reply. It would be great if you could post your previous spreadsheet, since I am always interested in other people's techniques. You mentioned that you used a hotlink, so I am assuming it was a DDE connection to the PLC. In my project I am actually moving away from DDE to OPC because of latency and stability problems. This problem isn't a major one, it is just bugging me that I can't figure out why this one feature is not working.

Don
 
Don,
I sent you a pm with my email since the file is 415 kb and the limit is 397.7 kb.

Bob
 

Similar Topics

Good Morning all can you help/advise me im have a configure ge9 driver Called ge9.ge9 path is (C:\Program Files (x86)\Proficy\Proficy...
Replies
1
Views
2,779
Hi Guys, I have got a problem regarding the setting of more than one limit for one input field. I have got four motors for extrusion & One for...
Replies
1
Views
1,659
Good day, I had installed the RSBizWare package. Installed and configured MS SqlExpress 2008. Created the database, and configured the OBDC data...
Replies
1
Views
1,809
Currently I'm using CC-Link modul QJ1BT11N as master station. The CPU I'm using is Q Series CPU, Q02(H). The problem is, I don't understand how to...
Replies
0
Views
2,786
I am working on a heat recovey system and need to regulate a modulating valve in order to maintain a temperature set-point. I have never used...
Replies
5
Views
5,844
Back
Top Bottom