Is it possible to read data from an rs232 port with VBA?

[JohanM]

I have to read data from an RS232 port to use it in Excel. Is it possible to do this wit VBA? If so, how do I do that? If not, is it possible with VB or is there another possebility to do this?

It would be great if someone can help me.

 

[ETID]

You need the Comm actived object....it's part of any VB stand alone version to use comm ports directly....or you can use the lpt1: port directly, Excel doesn't openly support it, but if you use...


open "lpt1:" for input as random... it should work


also another option, (hyperterminal will access com ports) make a dde link between hyperterminal and excel...and control the hyperterminal with the sendkeys command in vba....