Based on objects, there are a large number of internal objects and their properties and methods that can be used.

In addition, external object library references can be added to extend VBA functions.

You must ensure that the application provides an object library before you can perform this operation.

In the Object Browser, you can select the class in the Class box and select the method or attribute in the Member box.

Mscomm Control Excel Vba Code With It

Ive searched for info on CheapComm, and I downloaded the installation package, but there is no sample code with it, so Im not doing something right.

These are the lines of code that create the error (omitting the remainder of the subroutine).

The line Set CPort.

Sub ComPortTesting() Dim CPort As MSComm Set CPort New MSComm.

This is really a two part question: (1) Can this be done using MSComm (Or is there some basic problem like a licensingregistry issue) AND (2) Is there another way to communicate with the Com port using Excel that doesnt require MSComm Thanks --Jason.

I have a DLL and a form that I use with a few preset commands.

These are more or less in the public domain, and work very reliably.

If anyone is interested I will publish the code that I use.

Richard.

After either of these steps, the MSCOMM ActiveX control works.

So, if you have a more direct way to allow COM port communication, Id love to see it --Jason.

I use a simple solution called Cheapcom which is as far as I am aware Freeware.

It has an installer that installs the DLL and a simple set of commands for performing the various COM operations.

I have written a standard Excel book that contains a sheet with all the settings, Baud, Parity, etc., and I just tailor this to suit the application that I am writing.

It is possible to use any Serial Com Port with both ASCII and Hexadecimal.

Mscomm Control Excel Vba Professional Version Of

CheapComm was written to permit Visual Basic, Excel, and VBA (Visual Basic for Applications) users to use the Photon Technology International (PTI) serial port devices without requiring purchase of the professional version of Visual Basic (that comes with MSCOMM32, a decent serial port OCX), or an expensive serial port DLL that provides many more features than the SIDs require.

This control has also been used with to control other serial port devices.

This control can be used with any language that works with OLE controls (OCX controls).

CheapComm is a means of using the serial port for instrument control.

It is NOT meant for very sophisticated serial port operations.

To this end, CheapComm only exposes the most basic operations of the serial port.

It will send or receive ASCII or binary information, configures the port for basic communications, and clears the port buffers, and thats it The command set can be summarized in only a few lines: OpenCommPort(SerialPort as String, SerialFrame as String) as Boolean CloseCommPort() GetNumBytes() as Integer GetStringData(Buffer as String, Numchars as Integer) as Integer GetBinaryData(Buffer as Byte array, Numbytes as Integer) as Integer SendStringData(Buffer as String) as Integer SendBinaryData(Buffer as Byte array) as Integer SendSubArray(Buffer as Byte array, NumBytes as Integer) as Integer ClearCommPort() Thats all the functionality this control provides, but these few procedures can do a lot.

When the number of bytes reaches a certain value, the data can be removed from the serial port.

For more info give me an E-mail address and I will send a sample application.

My trouble was that I never got going I only wanted to send an ASCII string of four characters to Com 1 and see what came back, but was immediately lost in the technicalities.

If it is any use to you, I have written applications that use both ASCII and HEX, and have made my own routines for converting between DECIMAL, HEX, and ASCII as well as a converter for floating decimal.