Accessing com ports through Excel97?
 

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?

Accessing com ports through Excel97?
 

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

--
Regards,
Tom Ogilvy

"Michael Bowen" wrote in message
...
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?

Accessing com ports through Excel97?
 

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/SENI...OJECT%20FINAL%
20PAPER.htm


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

--
Regards,
Tom Ogilvy

"Michael Bowen" wrote in
message
...
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?


.

Accessing com ports through Excel97?
 

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

wrote in message
...
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/SENI...OJECT%20FINAL%
20PAPER.htm


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

--
Regards,
Tom Ogilvy

"Michael Bowen" wrote in
message
...
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?


.