Arduino Uno R3 serial version
This is the VBA Serial Port function set adapted for use with Arduino devices.
No other files, licences, payments or registrations are required.
Functions can be used directly in Excel cells as Formulas where appropriate.
No Arduino reboot on com port connection by design.
Separate Arduino reboot command if required.
Com Port
- Requires that the Arduino COM Port Driver is correctly installed and configured.
- Correct COM Port Number is defined at start of VBA module.
Read Functions
Assume that all data has already been sent by the Arduino is ready waiting to be read
-
check_arduinocan be used to confirm expected number of characters are waiting before committing read -
No pre or post read delays for any in-flight data reception to complete are provided.
-
Data will be read in one synchronous API call.
-
Maximum characters per read call =
READ_BUFFER_LENGTH -
check_com_portfunction can be used again to check for any new or remaining characters.
Write Functions
Writes are synchronous and functions can block until outgoing data is processed or write timer expires
- Short strings will return quickly as data is buffered for transmission
- Maximum number of characters sent is limited by write timer value in milliseconds
Control Functions
- Allow a few MilliSeconds for functions to return and for any attached hardware to stabilise
- Functions return
TrueorFalseto indicate success or failure
- Function returns number of characters waiting to be read
- Return number can be zero if no data waiting
- Return value of -1 indicates error, including port not started