1. Example Of Serial Communication Protocol
2. Recovery Toolbox For Excel Serial
3. Serial Communication

Recently, I got helpful advice on how to install and register MSComm32.ocx for a serial communication project I am working on. I have succeeded in getting it on my home Windows XP machine where I write code, and a PC at work running Win' 98. The work PC is actually hooked up to the serial device, a pump controller. Since then, I have established communication with the controller using Hyperterminal.

Using ActiveXperts Serial Port Component with VBA (Visual Basic for Applications) ActiveXperts Serial Port Component is a software development kit (SDK) that enables the user to communicate to a device over a serial interface. Drivers for windows 7 ultimate. 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. The first parameter specifies which network protocol to use, but as long as we are using Winsock 1.1, this network protocol is the constant PF_INET (Internet Protocol). The second parameter specifies which type of socket to create. Visual basic 6 excel rs232 serial free download. Free VCF file to CSV or Excel converter This is an Excel based VBA script used to import bulk.VCF files that contain more than 1 Vcard. 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.

The controller has its own serial protocol using ASCII characters. Commands from the PC begin with a 'start of text' <STX> character and end with a 'carriage return' <CR>. The controller responds with data, followed by <CR>. The body of PC transmissions may have 1- or 2-letter commands, sometimes followed by numeric parameters. The controller resonds with an 'acknowledge' <ACK> symbol, a 'negative acknowledge' <NAK> symbol, or numeric data.
Now that I am familiar with the controller protocol, I'm moving on to VBA code. I'm slowly working through a site, http://www.yes-tele.com/mscomm.html, a number of MicroSoft Knowledge Base articles, and code samples provided by Expert Exchange members, to get started writing actual subroutines. Perhaps someone can help me 'jump start' this part of the project with some simple code samples?
For example, I'd like to ask the controller what setup program is assigned to pump drive 1, '<STX>N1<CR> and display the numeric response from the controller, '#<CR>', with the carriage return removed. I envision starting with something like,
Private Sub Form_Load( )
With MSComm1

Example Of Serial Communication Protocol

.Settings = '9600,O,7,2' 'baud,parity,data bits,stop bits
.CommPort = 1
.PortOpen = True
End With

Recovery Toolbox For Excel Serial

although I've also seen statements like,
Open 'COM1:9600,n,7,2' For Input as #1
Is this equivalent to the previous 'With' statement?
Also, the protocol says the use of handshaking when communicating with the controller is optional. Should I ignore the Handshaking property, or set it to something?
A little advice, up front, should help me get this coding started.
Thanks.

Serial Communication