Hi
I do not know very much about VBA programming but I am sure that I have read somewhere that it can be used to send commands to an external device via the serial port.

at the moment I am using simple command line programs like Putty and Termite. I use it to send a whole host of commands but the problem is I have to type them in one by one without a simple way of storing and controlling multiple commands.

As an example I open putty and send the command "id" to the electronic device that I am communicating with and the device returns tect showing the product name and serial number.

If I could have a macro enable spreadsheet with macros assigned to command buttons then it would make my life much easier, however I am not sure where to start.

Could anyone offer a suggestion of code using the above example so a click on a command button would oped "Com 10" "Baud rate 9600" "parity 8" "stop bits 1" it needs to send the text "ID" and capture the response.


Thank you in advance for your kind help.