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
Manufacturers have software to program the programmable logic controller (PLC) or the human-machine interface (HMI). However, there are a few free tools that will help in the development of your PLC programs. We will look at three software tools and show how beneficial they can be to you. Free PLC Software Tools Synergy – Share … 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
Takt time is the beat of manufacturing. It is the rhythm of the company for making products or delivering services. Do you know what yours is? Let’s look at takt time and determine how to use it to our advantage. What is Takt Time? (Discover Takt Time) This is a German word taken from beats … Read more