Here is a post that I just finished. I thought that it would be worth sharing here.
Let me know what you think.
Thank you,
Garry
http://www.accautomation.ca
How to Implement Modbus TCP Protocol Using VBA with Excel
We will use Visual Basic for Applications (VBA) to communicate to a PLC using 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.
The following steps will be done:
1.Explain Modbus TCP protocol
2.Install OstroSoft Winsock Component
– Winsock API Calls for communication on network
3.Develop the Excel and VBA application
(Microsoft Excel 2010)
4.Communicate to the PLC and sample code
(Do-More Simulator)
Read the rest of the post...
How to Implement Modbus TCP Protocol Using VBA with Excel
Let me know what you think.
Thank you,
Garry
http://www.accautomation.ca
How to Implement Modbus TCP Protocol Using VBA with Excel
We will use Visual Basic for Applications (VBA) to communicate to a PLC using 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.
The following steps will be done:
1.Explain Modbus TCP protocol
2.Install OstroSoft Winsock Component
– Winsock API Calls for communication on network
3.Develop the Excel and VBA application
(Microsoft Excel 2010)
4.Communicate to the PLC and sample code
(Do-More Simulator)
Read the rest of the post...
How to Implement Modbus TCP Protocol Using VBA with Excel