Sign in to follow this  
Followers 0
Honda

Event logging tag value into Excel with time stamp

2 posts in this topic

Hello. I have application where I need to create event log into excel sheet with time stamp of the tag value form Control Logix CPU. There is no other software or HMI on the machine except Studio 5000. I have RSLinx single node licence and can get tag values into excel. I am wondering if somebody come across excel sheet with capabilities to log the data based on event. Any help much appreciated. Thank you.

Share this post


Link to post
Share on other sites

Been a bit since I've written excel macros / vba but if you place your triggering tag into a cell like "A1" and have the data_update module read the values and place them on the log sheet it should be doable.  I'd suggest checking the download section for the OPC Excel AB Logix examples.  One of those should be "tweakable" into what you need.

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