Hello,
I have a temperature monitor that is connected to my computer
via RS232 to COM1.
(The actual connection is via a COM to USB cable.)
Small records of 10 charracters + Carriage-Return are sent per communication.
I can receive the data with Hyper Terminal program of XP on COM1.
If I could direct the data to EXCEL then I could resume with the data collection.
I can try to create a program to write the data in comma separated format in a file but that is not my intention.
Is this possible to do without programming?
What is the best way to do this?
Thank you,
Harry Geda
Excel Macro - Visual Basic - Send command to serial port - Receive Data. Hello everybody, I know nothing of macros for Excel. Need of a model that does the following. Hey Everyone, I have just started using arduino and one of the first things i wanted to do was link my knowledge of VBA with arduino. I spent hours and hours researching serial communications from VBA. Excel VBA; serial port. I want to be able to access the serial port from excel! I want to send a command to the serial port 'IAVE' and then read back the four digit number that is returned and store this in a cell in excel! Have the command line program output the result to stdout, and pass it on to excel? Not exactly VB programming I.
This question already has an answer here:
- What is the best way to access a serial port from VBA? 3 answers
I'm trying to communicate an Excel Sheet with a device that communcates using a Serial port. I have mode some research and found a lot of paid software that does this for you. However, I really want to make it by myself and do it directly from Excel using VBA. The problem is, I'm not good enough at VBA and finding tutorials or example has been difficult. Maybe my question is off the topic but I really need help. I tried this Macro code but Excel crashes.
Thanks for reading and sorry if I made a mistake typing my question, english is not my native language.
marked as duplicate by Community♦Oct 21 '16 at 13:19
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.