Excel Serial Communication Example On Resume
I'm trying to figure out how to send a string of data to a com port.The receiving end of my string will be a machine that directs what it gets from me to certain machines.I will build the string using data from the user. I don't know if I should build a table first and then send the one line of the table to the port or try and build a string to send.The string will consist of 8 byte fields byte0 is a constant number of 400 while byte 1 - 7 will be data from the user.I started by building a table and then just updating the table with the data needed. However I don't know if I can send the single line of data from the table to the com port.I'm really looking for any advise on a good way to do this.Thanks for all your help in the past and looking forward to your good insight. It looks like you have a workable approach available Tom. Unfortunately, you need someone with the understanding of that particular API to help you.I assume you know that this code will actually be allowed to run? As I said earlier, standard code not have direct access to the hardware.
On the other hand, it may well be that the API you're using goes from a position of trust (IE. From the correct side of the HAL - Hardware Abstraction Layer - of the OS).I could help on the VBA side, but it looks like that isn't what you need here. Option Compare Database.'
How To Read Serial Port Data In Excel 2016
Attribute VBName = 'modCOMM'.Option Explicit.' -.' modCOMM - Written by: David M. Hitchner.' .' This VB module is a collection of routines to perform serial port I/O without.' using the Microsoft Comm Control component.