Capturing Data from a Com Port or Printer Port

[Newby :)]

How would I go about capturing the data sent via a port into a excell spread
sheet by clicking on the cell ??

Can any one help me , Thanks

 

[Tom Ogilvy]

If you are using a bar code reader, many of these come with a utility which
will stuff the input into the keyboard buffer - then all you have to do is
select the cell so it has the focus for keystrokes, then read the code. The
utility adds in a CR at the end of the stream

 

[Newby :)]

Thank you but this does not help me , how do i go about achieving this ???
I am wanting to pull the data from a digital scale but want to via a macro
or other means to be able to when I click on a cell it must read the data and
put it in a cell.

 

[Tom Ogilvy]

The best place to ask would be the makers of the digital scale.

A previous answer to a similar question:

===================

posted by eric in programming 10/27/2003

In the VBE, create a userform. Next, create a
communications control (Microsoft Communications Control,
version x.x) and name it Comm1.

In the properties window of the communications control,
see what the name is. We'll name this one comExcel for the
examples below.

Then in a module, type:
Comm1.comExcel.CommPort = [Enter the com port here]

Comm1.comExcel.Settings = "9600,n,8,1" 'enter your own for
your device

Comm1.comExcel.PortOpen = True 'opens the port

Comm1.comExcel.Output = anything that needs to read from
the computer to the PC

Use at your own risk!!!! This code works for our weight
scales, but you'll have to read your manual to get the
output you desire. If anyone has any other suggestions,
please feel free.

---------------------------------------


Here is a link to some general information on the MSComm control:

http://www.yes-tele.com/mscomm.html

---------------------------------------
Another Option:
Unfortunately Excel makes it almost impossible to do serial
communications directly using VBA.
Fortunately there are other easy solutions for inputting serial data
into Excel from devices like scales, measuring tools and bar code
readers.
The company that I work for sells a serial communications program
called the Software Wedge that you may find to be a good tool for
adding serial communications capabilities to your application. The
Software Wedge is an executable program that can pass serial data back
and forth to other programs using either DDE (Dynamic Data Exchange)
or by converting incoming serial data to keystrokes (i.e. it stuffs
the keyboard buffer with the incoming serial data).
The program is extremely easy to use and is designed to have you up
and running sending and receiving serial data directly from within
your application in just a few minutes.
Please visit http://www.taltech.com for more information.


------------------------------------------

This link has some free utilities from TalTech:

http://www.taltech.com/freesoftware/fs_sw.htm

-------------------------------------------

Fred Cummings Excel page has information on the serial port interface with
Excel:

http://fcfhsp.customer.netspace.net.au/xlhome.htm



------------------------------------------

Regards,

Tom Ogilvy