Excel communication to serial port

[sinbad22uk]

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.

[mjr veverka]

You seem to know more than others ...

Maybe in this way or similar (when it comes to sending codes):

Please Login or Register  to view this content.

, but this matter is rather strange/unfamiliar to me ... sorry ...
In my opinion, you also need to have a proper/adequate 'control' to communicate with the electronic device ( ? mscomm.ocx, mscomm32.ocx, ietimer.ocx ?)

See this topic and related:
https://support.microsoft.com/en-us/...s-oncomm-event

... and also in the forum ...