For only 35$ USD only with Bill Redirect software WWW.BILLPRODUCTION.COM
you can communicate with your peripheral (balance, bar code
reader...).

With this software you can read the serial port and data is entered
directly into Excel via a DDE CONNECTION

The Software BillRedirect is an executable program that can pass
serial data back and forth to other programs using either DDE (Dynamic
Data Exchange) or by converting incoming serial data to keystrokes.
The program is extremely easy to use and is designed to have you up
and running sending and receiving serial data directly from within
your application in just a few minutes. Please visit http://www.billproduction.com
for more information.

WinWedge Std: $259
WinWedge Pro: $495
BillRedirect (that make the same job !): 35$

* If you need a fonctionnality in BillRedirect ... Usualy it's Free if
you order a 3 copy !
* With BillRedirect the technical support is free !

On 26 avr, 02:25, "Alexi Dobrev" wrote:
I am trying to read and write data to COM1 based on an excel table, but
can't find a way to do it directly from VBA.

Any idea how to use mscomm32.ocx in VBA form?