Serial Ports in VBA

[Kleber]

Can I use the serial port with VBA?

 

[Paul Keister]

This is not the best way to access a serial port, but it could in theory be
done. Take a look at this knowledgebase article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;823179

Even though this is written for VB.NET, it uses the good old fashioned
Windows API calls (see the section "Declare References to External
Procedures That Are in Kernel32.dll"). You should be able to adapt this
code backwards into VBA.

Good luck!