Tags: port, serial, vba 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. Aug 25, 2009 I have a spreadsheet I originally created in Excel 2003 which used the MSCOMM control to read data sent to the serial port. When I upgraded to Excel. Serial To Excel VBA without MSCOMM. Ask Question. Up vote 0 down vote favorite. Read a Serial port in Excel 2013 using VBA. Connect Sap Through Excel VBA. Nov 21, 1998 Excel can communicate in and out the serial port both with API calls and with the MSCOMM.OCX control. Both techniques require some fairly serious VBA code as well as.

Excel can communicate in and out the serial port both with API calls and with the MSCOMM. One Piece Unlimited Cruise Sp 2 Rom. OCX control. Both techniques require some fairly serious VBA code as well as a deep understanding of either the Windows communications API or the intricacies of the MSCOMM control.

I can tell you from experience that the first option is absurdly difficult and the second option is not altogether reliable. I have heard that the latest release of the MSCOMM.OCX control is more stable than the original however I have never had good results with it. You may want to look at some of the other commercial communications OCXs out there. If you are interested, the company that I work for sells a serial communications program called the Software Wedge that you may find to be a good tool for adding serial communications capabilities to your application. The Software Wedge is an executable program that can pass serial data back and forth to other programs using either DDE (Dynamic Data Exchange) or by converting incoming serial data to keystrokes (i.e. It stuffs the keyboard buffer with the incoming serial data).

The program is extremely easy to use and is designed to have you up and running sending and receiving serial data directly from within your application in just a few minutes. Please visit for more information. On 12 Nov 1998 03:49:24 GMT, (RandyDtg) wrote: >Can Excel VBA (Visual Basic for application) talk with Com Port? >Can Excel VBA (Visual Basic for application) communicate using MSCOMM, or does >that requre Visual Basic? >>Or is a solution some use of DLL's? >>Please suggest sources of information/examples. Instrumental Song To Burna Boy Run My Race.