read serial data

[Guest]

How can I use Visual basic in Excel to Read serial data from an external
device.

 

[microsoft.news.com]

why do you need excel to do this? You can use VB and insert it into excel.
is that what your trying to do?

"How can I Read Serial Data" <How can I Read Serial
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Guest]

Yes Sort of. We have Visual basic in excel and often write macros. I just
do not know the commands necessary to read the streaming data.

 

[Thomas Lutz]

To write VBA code in Excel to do serial I/O functions would be
extremely difficult. Your best bet is to use a tool that is designed
for the job. One product that you might look at is called WinWedge
from TAL Technologies. WinWedge is an executable program that is
designed to run in the background and feed incoming serial data
directly to other programs as well as send data out a serial port from
other programs. It is typically used to interface all sorts of
instruments directly to an Excel spreadsheet.
For more complete information visit:
http://www.taltech.com/products/winwedge.html

 

[Modeste]

Hello,
it is not really difficult, but you must have :
- the device documentation...
and activeX MSComm32.ocx
here is a sample for weighting process with VBA (sorry but In french)
http://cherbe.free.fr/rs232.html

;o))
@+