Send V to com port

How do you send the capital Letter "V" to a port from Excel?

Excel 2002 on Windows 2000

If you have a licensed copy of the MSComm ActiveX control then you
could use it to send a string out the serial port from Excel however
if you do not then you will either need to write some fairly complex
code in VBA or use a third party tool to do the job.

One tool that you might look at is a product called WinWedge. WinWedge
is mainly designed to read in serial data and feed the data directly
to another program like Excel however it also has features that you
can use to send strings out a serial port directly from Excel or other
programs.
For more information about WinWedge visit:
http://www.taltech.com/products/winwedge.html

There is also a free program called SENDFILE that can be used to send
the contents of a disk file out the serial port at:
http://www.taltech.com/freesoftware/SendFileSetup.htm

The Sendfile program can be run from a VBA macro where you supply the
name of a file that you want transmitted out the serial port on the
command line to the program.

For example, suppose that you install SENDFILE in a folder named
C:\SENDFILE and you have a text file named "V.txt" in the same folder
that contains a single character "V".

The following VBA subroutine in Excel would send the contents of the
file out the serial port:

Sub SendVfile()
x = Shell("C:\Sendfile\Sendfile.exe C:\Sendfile\V.txt")
End Sub

To set the serial communications parameters for the SendFile program,
run it once and enter the communications parameters that you need to
use (COM Port, Baud rate, parity, databits, etc.) and then close the
program - it will save these settings and use them by default whenever
you run it until you change them.



On Mon, 13 Jun 2005 05:42:02 -0700, FGM
<FGM@discussions.microsoft.com> wrote:

>How do you send the capital Letter "V" to a port from Excel?
>
>Excel 2002 on Windows 2000