Visual Basic For Applications

Excel Secrets: Implementing Modbus TCP Protocol with VBA!

by

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

Omron Host Link Protocol Part 2 – VBA Excel

by

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