Import data from COM-port in Excel

[test]

Is it possible in VBA to send a string to a COM-port,and then listen
to the bytes send back?

I have a "device" that listens to a certain string (via a virtual
COM-port).
As soon as it reveives this string, I can program it to send data
back.

The device is something that I can program myself.
Untill now I tried it with a simple string: I send "b" for begin to
start the data.

The data are 3 bytes in a row
And maybe a few hundreds series of these.

Any ideas?

 

[David Lloyd]

One alternative to look at would be the MSComm control. This allows serial
communications with COM ports. I don't have enough information to know
whether this would fit your needs, however, you may want to take a look.

http://msdn.microsoft.com/en-us/library/aa259393(VS.60).aspx

David Lloyd
Lemington Consulting
http://lemingtonit.com

 

[Stefano]

I did use the MSComm control for years.
It is not distributed now, but I kept copying from old computers and
registering it manually.
But with Windows 7 it doesn't work anymore.

http://groups.google.com/group/micr...5353?hl=en&lnk=gst&q=stefano#cc5eefe75c305353

Stefano