brisutterfield

I am updating carton throughput and conveyor downtime in an Excel sheet using DDE hot topics. Does anyone know VBA to have the Sheet1 automaticaly save to the 'C' drive at 3 PM and 3 AM?

I have this VBA code in my worksheet: Public Sub TestPoke() RSI = Application.DDEInitiate(app:="RSLinx", topic:="PDCPICK2") disable = "N36:0/11" Set rangetopoke = Worksheets("Sheet1").Range("c1") DDEPoke RSI, disable, rangetopoke DDETerminate RSI End Sub I am poking the value of cell C1 (which is 1) to N36:0/11 in the logic. This is to enable a conveyor line. Once the conveyor line starts, O:014/16 becomes true and an indicator light on the panel lights up to signal that the conveyor line has been enabled. I want that Output, O:014/16, to trigger the logic to change the value of N36:0/11 back to '0' somehow. I tried a CLR instruction but that only works on words not bits.

I want to insert a RSTrendX graph into my Excel worksheet to graph/plot the value of 'N86:100' in a PLC program. I can not set up the Pens properly in RSTrendX. Is anyone familiar with that application?

What you described is exactly right. But I'm not very good at Writing VBA. I'll research the link you provided and see what I can come up with. I could also insert a RS TrendX object in my Excel sheet. This should graph or plot the conveyor speed for me also. I cant get it to work though.

I am using a RSLinx hot topic in Excel to display a conveyors speed in feet per minute. Typicaly is is around 540 fpm. Lets say that is in cell A1. Also I have another RSLinx hot topic in cell A2 that displays the time that is set in the PLC. Actualy, just the seconds. Status bit S23. So its value will be anywhere from 1 to 60 and update every second. I want to create a line graph in excel that will plot out the conveyor speed. When the conveyor starts the line should start to raise. Starting out from 0 fpm and eventualy climb to +-540 fpm. and the line should also plot the last 30 seconds at all times. Is anyone goodwith graphs that could help me?