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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Usage of serial port in VBA ( exel ) 2
VBA Excel 2
Select Text to End of Footnote 9
VBA: Serial I/O using kernel32 0
Com port samples on Access VBA 1
Send data to serial port 3
Serial communications 2
Dynamic Naming of Form Button 3

Top