Sign in to follow this  
Followers 0
balerjoe

Allan Bradley To Excell

4 posts in this topic

Guys I know this can be done. What I'm trying to do is tie in the load in & out meters in the plant to a excel spreadsheet. This will give a a accurate count of incoming product and out going. In the plant as the machines do there processes they have meters I want to tie this in as well. This will give me accurate count of product coming off the machine. As well as give me some shrink numbers. Help with scheduling loads as well. Any help in this regard will be appreciated. Thanks Edited by balerjoe

Share this post


Link to post
Share on other sites
First of all, do you have RsLinx Single Node, OEM, or Professional? RsLinx Lite will not work. After that, go to you help in RsLinx. Go to the Index tab and type in Excel. Below that you will see DDE Macro. From there you have pretty good examples of reading and writing a word or a block of words. I think RsLinx Lite also has the same help documentation but it is not capable of DDE Also you are limited to somewhere around 121 words per DDE request

Share this post


Link to post
Share on other sites
Assuming you are working with an AB PLC and not an AB Panel Meter the attached spreadsheet should give you a good startiing point. I hope it is well enough documented. SampleDDE.zip

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0