Hi Franz,

Franz wrote:
Jake you're my hero..... it worked perfectly .... thanks

Glad to help.

Hey, do you know how to read the COM port into Excel?

I've never done it before, but there is an MSComm ActiveX control that will
do this type of thing. I think it ships with VB 6 and maybe with Office
Developer edition. Here's more info on it:

http://msdn.microsoft.com/library/en.../vbobjcomm.asp

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]