Implement the Omron Host Link Protocol Using VBA

[gclshortt 51]

Here is a link to a blog post that will use Excel VBA to communicate to the Omron Host Link. It program NETComm.ocx for the serial driver. Here is pat of the blog... In Part 1, we used VB6 to communicate from the computer to the PLC. We will now use Visual Basic for Applications (VBA) to accomplish the same task. NETComm will be the serial driver and Excel will be the program that we will use. Using Excel we will have access to the Excel Object Model so we can utilize worksheets, ranges etc. Please refer to Part 1 (How to Implement the Omron PLC Host Link Protocol) for the details of the wiring of the serial port and protocol sequence. Continue to the blog post... Thought that I would share. Let me know if you have any questions. Thank you, Garry