Passing HEX or ASCII to a com port

T

Thanks

Hello
I want to create a button in Excel that when I click it, it will send either
and ASCII or HEX command to a COM port to control the on/off function of a
receiving device. So I’m thinking the if I put my HEX in cell A1, then the
macro would open the com port, grab whatever is in cell A1 and pass it
through the com port. It will probably need to close the port after the
command has been sent too. I wouldn’t mind being able to get a read back
status, but my first thing is to be able to send the command code. I saw a
few forums where someone gave a similar example, but they kept referring to
MSComm through VB. I have not been able to understand how to apply MSComm
after downloading it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top