Data tag value to excel and stack

Mpoon

Member
Join Date
Sep 2004
Location
Toronto.ont,canada
Posts
41
Hi, need some help for display PLC data from CPU data tag onto an excel form,
Data tag from Contrologic 5000 CPU hot linked to excel with Rslink DDE/OPC topic

=RSLINX|COL1_MIS!'DateTime[4],L1,C1' (It is Minutes of the CPU time) this part work, data is display in excel A1
My question is, how to move data from A1 to A2 and disply the newer data (CPU Minutes) in A1,whenever the minutes count has increaased, Other word say how to push data to next cell A1 to A2, and fill up new data to A1, I believe it need Marco or VB code? Any one done it ?

Thanks in advance
 
Last edited:
Here is a spreadsheet with a macro that copies the minutes in Cell A1 downward to the next 9 rows, when the UPDATE button is pressed. You can probably edit the macro to run automatically when 1 minute has passed (when the Excel function MINUTE(NOW()) = cell A2 + 1).
 

Similar Topics

Hi, I have a complex database in Crimson 3.0 and in one of the display pages I am trying to get a tag to show the sum of several other tags. The...
Replies
3
Views
163
My current situation is a follows: I have two similar 1769 controllers with similar programs. Both have a UDT array that is being used to store...
Replies
6
Views
237
Is there a way to move a tag value, brought into the panelview via modbus tcp with kepware, back to the plc on eth/ip. IE on the C-Mores we bring...
Replies
0
Views
425
Kindly, we are having a problem on a machine during night shifts, while no engineering tool is online. So, we were thinking of programming some...
Replies
9
Views
760
Dear colleagues, I am reaching out for assistance with an issue I am having. I have a code that can successfully insert data from FactoryTalk...
Replies
6
Views
1,047
Back
Top Bottom