Can I use the serial port with VBA?
P Paul Keister May 4, 2005 #2 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!
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!
