OK. So I've finally figured out how to read a com port with vba+
How to Read Com port I can post my code below ... It works, however, you need something going over the com port or you can't use this. What I'm doing is an Arduino project that sends data back over the serial port ( com4 in this case ) and its output is below the code.
What I need to know. Is how do I figure out the number of bytes to get from the port ( it's set from the example @ 64 ) from the displayed output how do I decide how many to get. OR better .... how do I "watch" the com port and have it tell me it has msg ready.
I'll just attach the workbook instead of code!
The following is the output from the arduino!
Sample RAW Bits: 0011 1000 0000 0000 0001 0010 0000 0000 0100 1010
Sample OK: 18 *C, 50 *F, 56 %