Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send V to com port
How do you send the capital Letter "V" to a port from Excel?
Excel 2002 on Windows 2000 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send V to com port
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 wrote: How do you send the capital Letter "V" to a port from Excel? Excel 2002 on Windows 2000 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Port 119 for NG | Excel Programming | |||
COM Port help please | Excel Programming | |||
Accessing the USB Port | Excel Programming | |||
Com Port and VBA from Excel | Excel Programming | |||
need help re send/recieve com port data from excel and auto CR/LF | Excel Programming |