Serial communications

[Don W.]

Is there any way to access a serial communications port (com1) using VBA?

I'd like to create a module in Excel to retrieve data from a bar code
reader via the com port.

Don W.

 

[Tony Jollans]

There is a long thread about this on Tek-Tips - see
http://www.tek-tips.com/viewthread.cfm?qid=560230&page=1

 

[TC]

AFAIK, you just open & read from it using the win32 APIs CreateFile &
ReadFile respectively.

If the other answer does not help, googling on something like this
might get you started:

createfile "declare function" port

HTH,
TC