Send Excel data via COM port

[maharg]

Hi

Can anyone tell me how to send the numeric value in an Excel data cell out of the RS232 COM port of my PC?

Thanks, in anticipation

Graham Laming

http://www.london-electronics.com

 

[ETID]

You'll need an API Comm object...maybe you can load it via the ref. library, and that is assuming that you have a program installed on your pc (like visual basic 6.0) that has a comm object.

If not then you can use the lpt1 port this is not documented, but does work...


example:

open "lpt1:" for output as #1 'you might not need the colon
print #1, range("b3&quot
close

 

[ETID]

oops not API...but ActiveX

 

[maharg]

Thanks for that ! I'll give it a try.

Regards

Graham