How to Implement Modbus TCP Protocol using VBA with Excel

Excel Modbus protocol communication can be done using Excel. Modbus TCP uses ethernet communication media. We will use Visual Basic for Applications (VBA) to communicate to a PLC using the Modbus TCP protocol. Reading ten registers in the PLC and displaying a bar graph in Excel. Previously we have used VB6 to communicate Modbus TCP. A more powerful and robust logging system can be obtained by using Node-RED. Here is the series that will take you through installing, collecting data, saving to a database, and sharing this information with multiple users. More information can be obtained on our website. 00:00 Modbus TCP Protocol using VBA Excel 00:30 Installing the Winsock Component for Ethernet Communication 01:08 Do-More PLC sample program / PLC Simulator 02:30 Excel Spreadsheet - Modbus TCP Information 03:33 VBA program in Excel - Visual Basic Components 04:30 Retrieving information from PLC to Excel ACC Automation