Practical Tips and Techniques
We are using Modbus TCP protocol, reading ten registers in the PLC, and displaying a bar graph in Excel. e will use Visual Basic for Applications (VBA) to communicate with a PLC. Previously we have used VB6 to communicate Modbus TCP. Sequence for Modbus TCP on Excel using VBA The following steps will be done: … Read more
Utilizing the CX Server DDE Manager will allow us to provide a link to the information in the Omron PLC. This link can be placed on an Excel spreadsheet. Charts, graphs, etc., can be made from the data. We will create links on an excel spreadsheet from a CQM1H and a CP1L PLC. The information … Read more
We will use VBA in Excel to communicate to an Omron PLC. This will use the serial host link protocol. ACC Omron Host Link VBA In Part 1, we used VB6 to communicate from the computer to the PLC (Host Link Protocol). We will now use Visual Basic for Applications (VBA) to accomplish the same … Read more
Sending email messages from the PLC sounds like an easy task. However, very few applications do this on the production floor. This is probably due to the networks involved, and authentication can be complicated. In our example, we will use a restricted Gmail SMTP server so that no authentication will be required. We will walk … Read more
We will look at a PLC basic tutorial of a paint spraying station. Following the five steps to program development, this PLC programming example should fully explain the procedure for developing the PLC program logic. Ladder logic will be our PLC programming language. We will use the Do-more Designer software, which comes with a simulator. … Read more
We apply the five steps of PLC development to a plc shift register example. This PLC programming example will use a shift register to reject a product on a conveyor. When programming a PLC, you need to track what has previously happened. Shift registers allow you to do just that. We will look at a … Read more
