B11, allow this macro to write a block of data. Status returns the current status of the processor as a string Ok or Faulted. The following macro writes a value to N7: Bugs were filed with both parties over 2 years ago and so far it has not been fixed.
I have a lot of experience using this software and it works really well. Then you can make a button to reference the macro, for example: ProcessorName returns the name of the program running in the processor.
With DDE it happens much quicker. Focus your effort on the intimate understanding of the business, and making great reports that add value. This software allows you to map to every register within the SLCincluding the s registers which provide status information about the CPU such as faults etc.
I would add that if writing into a PLC register from an Excel cell, adding some code to make sure the cell value is numeric, and fits within the bounds of signed bit architecture is probably a good idea. I have also been looking at a similar product called XLReporter.
Let Excel Reporter take care of getting data, and scheduling reports. I have no idea if all that information can be extracted from RSLinx into VBA, and then again it may be overkill, but it would be handy to have in there The serial port version is almost identical.
Then it will restart after that. Alternatively, it may be possible to upload the program and then navigate the COM object model of the automation interface to find the data you need.
Period It is just for programming so that is not a problem. Revision returns the firmware version of the processor as a string.
Rslinx dde write a check is used to switch between alias topics in OPC clients. A connection is effectively the buffers and other data that the PLC has to store and maintain. I remember doing it more elegantly at one time, but that formula always "smart copies" nicely.
Thanks So much, Both of you Matt December 2nd, Larrin From RSLinx help: The time out value is consistent with the communications timeout value in the configured PLC-5 topic. Here is a link to a KnowledgeBase article at Kepware that talks about the bug. I could imagine a scenario where you use this interface to upload the program and then either convert the program to a text format or export the comments.
Simply talk the protocol directly with the PLC. Not going to post them yet AS I want to see now with the proper format if I can get the same results to just trigger a BIT instead of an integer. I suggest searching around for Unix libraries since these tend to be very standard and open source code.
Yes, having the input pattern completely filled with ones and zeroes is a brain pain, but I do that for display purposes in printed form. The following predefined items are used with Logix family processors: FreeMemDT returns unused data table memory not applicable to L1.
Just knowing that the DDEInitiate failed would be enough for me. IsPresent allows you to check if your ControlLogix processor is available prior to performing reads or writes.Jun 29, · In the following video you will see how to configure an OPC/DDE Topic in RSLinx to grab live data from a Logix controller and.
Mar 26, · DDE/OPC RsLinx (Excel) Configure RSLinx DDE OPC Topic to Get Data From a Logix Controller to MS Excel - Duration: Brett Allen 16, views. Introduction to Writing Excel Macros.
Here I use the DDEpoke instructions and run my macro which writes the data perfectly to my PLC. Now I want this operation to be done automatically. Whenever the values in a column changes (based on the calculations made in the previous columns) the DDE enabled macro has to run the macro for writting those tags to PLC.
RSLinx Classic supports a wide range of applications through a scalable offerings that provide both DDE and Classic OPC DA data servers to permit 3rd party software to access information within your control system.
I was just trying to illustrate for the OP the basic concepts involved in writing data into a PLC register using DDE/OPC on RSLinx. I would add that if writing into a PLC register from an Excel cell, adding some code to make sure the cell value is numeric, and fits within the bounds of signed bit architecture is probably a good idea.
Oct 12, · =DDE(rslinx, PLC1, "N" Now in VB and VBA not so quick I hope you are familiar with these because you will need to do things like open a channel to rslinx before DDE reads and DDE pokes.
I found if you are going this method make sure the data you need is lined up tight.Download