Hello Qwerty,

If the communications software for the comparator exposes VBA routine
in Excel then your task will be much easier. If not you could writ
your interface using Visual Basic (not VBA) and write a DLL to provid
the low level link needed to the serial port. I would advise agains
it, unless you have the electronics and software background an
experience with low level coding.

It could be the comparator is communicating via DDE (Dynamic Data Link
or RTD (real Time Data). Either of these methods has VBA interfacin
with Excel. You could easily construct a button using VBA to read i
the information.

Happy Holidays,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=49591