Accessing com ports through Excel97?

[Michael Bowen]

I'm trying to write a program that would access an
instrument plugged into the com1 port, and would like to
do it through Excel97. I could not find any ActiveX tools
that would be capable of doing this. Any hints, comments,
suggestions?

 

[Tom Ogilvy]

have you looked as the mscomm control? It is distributed with VB6 I
believe.

 

[Guest]

I did it before with win95io.dll from
http://www.softcircuits.com/sw_tools.htm
It only works in 98 though, because win2k won't allow
direct port access. I think I have some code samples here
(this project was the only place I used it but it was
almost 2 years ago
http://www.columbia.edu/~cp2065/SENIOR PROJECT FINAL%
20PAPER.htm

 

[Art D.]

If you are trying to accomplish data aquisition via a com port, you may need
a 3rd party software wedge. I had this issue at work, and we looked at
LabView, but eventually settled on WinWedge32 from Taltec.com. Good utility
that captured the data, can parse it using any delimiter into fields, and
acts as a dde server for excel if needed.
good luck