Computers & Electronics
Education
Science
How to Implement Modbus TCP Protocol using VBA with Excel
6K views
·
Sep 10, 2022
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.
https://accautomation.ca/series/node-red-iot-enabling-software/
More information can be obtained on our website.
https://accautomation.ca/how-to-implement-modbus-tcp-protocol-using-vba-with-excel
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
https://www.accautomation.ca
Show More
Show LessComments
loading text loading
loading text loading
loading text
loading text loading
loading text
loading text loading
loading text
loading text loading
loading text