This is the snippet Send/Receive Data Via the Serial Port Using MSComm Control on FreeVBCode. The FreeVBCode site provides free Visual Basic code, examples, snippets. I need to read and write byte arrays using COM-port and VBA. I found a nice solution here But this solution works only for String type for input/output data.

Optional Serial Port Drivers to use for Visual Basic for Applications VBA Serial Port Control Software Example Since you were unable to use the mscomm32.ocx Communications Driver for our example, you will need to choose one of the following options that are available to continue our demonstration. The information listed below, are links to other sites not maintained by Pencom Design, Inc. If you use this information in your software designs, make sure you are not violating any copyright's of the authors. Spotmau Powersuite Golden Iso Torrent here. Some authors choose to distribute software to the public domain, and it may be used in your software without restrictions, you need to contact the author to be sure. To check out these sites without interrupting this demonstration, you may right click on the links and open then in another window.

This will allow you to download and setup the OCX driver or API calls and continue when completed. - This driver is a replacement for the mscomm32.ocx with some small differences. You may view the information on the driver, author and setup information, by following the link above. To directly download the NETcomm driver setup program, it's a 2.5 MB zip file. After downloading and installing the NETcomm driver, to continue the serial port demonstration using this driver. - Instead of a driver this code uses calls to the Windows API and eliminates the need for a OCX driver.