How To Implement Modbus TCP Protocol Using VBA with Excel

[gclshortt 51]

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 protocol2.Install OstroSoft Winsock Component– Winsock API Calls for communication on network3.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 Here is a blog post that I thought was good to share. Let me know what you think. Garry http://www.accautomation.ca

[jawolthuis 0]

Very nice! I have never used vb inside Excel before. Thanks for the example!