Usage of serial port in VBA ( excel )

A

Alexi Dobrev

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?
 
J

jaf

Hi Alexi,
If you have used mscomm32 in VB5 or 6 its the same in VBA.
Right click the controls toolbox. Find & check mscomm32. Drag the new icon
onto your form.
 
Top