![]() We want the macro to automatically run at the end of every complete machine cycle. Right now the data is written to a database by a macro that runs whenever the operator selects the shape that has the assigned macro. =(RSLINX|CE!'F17:3,L1,C1') where CE! is the “communication channel”. ![]() Excel sees the data stored in the PLC’s memory using cell content like this. The PLC receives pressure measurements into its memory from pressure transducers wired into input channels with analog to digital conversion. That program runs an inspection machine through a cycle. The PLC executes a program when the operator simultaneously pushes two real-world palm buttons (discrete PLC inputs). (Yes, Excel is a terrible human-machine interface, now I know why. (I hope I’m saying this correctly.) Effectively, Excel running on my panel-mounted touchscreen all-in-one computer running Windows 7 is my operator interface for the PLC. You will have to sift through this info to pick out what you really need…īackground: Excel and the PLC communicate using RSLinx Classic (Revision 2.57.00.14 CPR 9 R 3) software as the interface. Currently the only trigger is a shape inserted directly inserted into a sheet, with a macro assigned to the shape. They're pretty durable, but I've seen SLC-5/0x ports get damaged by voltage spikes (non-isolated radiomodems are notorious) or just by physical abuse.Goal: I am trying to get Excel 2010 to execute an existing macro, with the trigger being an external command or action from an Allen Bradley MicroLogix1100 PLC (Programmable Logic Controller) through RSLinx Classic software from Rockwell Software. The last possibility is, of course, that the port has been damaged. SLC controllers can be configured to run ASCII, or DH485, or Modbus, or even to shut down the Channel 0 port. The 1747-CP-CP3 cables from Allen-Bradley are ideal, but any straight serial cable with a null-modem adapter should work.Īnother possibility is that your offline file doesn't match the port configuration that is actually running in the controller. To run DF1 Full Duplex protocol without handshaking, you only need Pins 2,3 and 5, with pins 2/3 swapped between the PC and the controller. Remember that Autoconfigure is convenient but not required if you have the Offline file you can enter the speed/data/parity/error checking/Device Type values directly into the driver. ![]() The best USB/RS232 device I've used is the Keyspan USA-19HS I've bought a half-dozen of them because I give them away to users who are having this sort of problem. Many add-on serial ports cannot keep up with the rapid reconfiguration changes. When the controller responds to the Echo command, RSLinx sends a longer command to confirm the BCC/CRC error checking method and determine the Device Type. ![]() The "Autoconfigure" feature works by rapidly reconfiguring the port for different baud/parity/stop features and sending a two-byte "Echo" command (0x10 0x05). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |