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

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
wrote in message
...
How can I use Visual basic in Excel to Read serial data from an external
device.

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.

"microsoft.news.com" wrote:

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
wrote in message
...
How can I use Visual basic in Excel to Read serial data from an external
device.

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


On Thu, 19 May 2005 12:49:02 -0700, "How can I Read Serial Data" <How
can I Read Serial wrote:

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

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))
@+

quite Thomas Lutz wrote:
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


On Thu, 19 May 2005 12:49:02 -0700, "How can I Read Serial Data" <How
can I Read Serial wrote:

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