The routine CommGetError can be used to get ' the complete error message. ' ' All routines (with the exception of CommRead and CommWrite) return an error ' code or 0 if no error occurs. ' ' The routine can handle up to 4 serial ports which are identified with a ' Port ID. This module uses the Windows API ' to perform the overlapped I/O operations necessary for serial communications. Serial Port Communication Script Option Explicit '- ' ' This VB module is a collection of routines to perform serial port I/O without ' using the Microsoft Comm Control component. The comments in the code are self explanatory.The article continues after the end of this code, please scroll all the way down. This Visual Basic Code “defines” the constants, structures andĪPI functions that you will use later to perform the intended operations.

Once you reached this stage, copy paste the code below in there.

The effect of this action will be the opening in the main window of this environment of the actual sheet in which you will write the VB code. This will make visible another small toolbar, with the following buttons: Once you have started your Excel, choose from the top menu: View -> Toolbars -> Visual Basic. In order to get access to the VBA script editor, you first need to make the corresponding buttons available on the Excel toolbars (they are not there by default). It is assumed that the reader would have some basic knowledge of programming (but really basic, not even intermediate) NET Framework and of the C# compiler itself. Even the method of programming in C#, which I have suggested in a different article ( Serial Port Communication in C#) needs the installation of the. Other methods always require the installation of an ActiveX, or at least the registration of an “.ocx” file, like for instance the MSComm control. The great advantage of this method, which uses API functions to call the serial port directly, is that you do not really need to install anything on your PC, apart from the Excel itself (which, let’s admit it, already exists on most PCs). The purpose of this article is to demonstrate how you can perform serial port communication in the VBA (Visual Basic Applications - script editor included in any typical Microsoft Excel distribution) but without using the MSComm control or any other third party add-on or ActiveX. Introduction to Serial Port Communication in VBA

Excel Vba Serial Port Programming