Receive data from COM port.

[Harry Geda]

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

 

[John_w]

ingvarlinden, it's better if you stick to your own thread - http://www.mrexcel.com/forum/excel-questions/745751-read-serial-com-data-gps-into-excel-vbamacro.html - which is specific to your situation. I will reply in that thread.

 

[rickuae]

You could use VBA file I/O to read data from the COM port into Excel. The following example polls the COM5 port every 200 milliseconds for 30 seconds and displays the data received in the Immediate window. To make it work with COM1, just change the Open statement.

Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
.[/QUOTE]

Hi and thanks for this code, this something that could work for me.
I have a serial device connected to the PC via USB to Serial interface cable on COM5.
I copied the code into a module in Excel 2007 and ran the code, it's running but it also hangs and does not stop run until I pull out the USB to serial cable from the PC.
I changed the baud rate to 19200 as per the device setup but I cant get the transmission to work.
Any ideas what can go wrong here.
Really appreciate your thoughts

Regards

Rick

 

[James Turner]

I tried this and I get an error invalid procedure Opencomm, even though it clearly is there. Could this be a reference issue?

 

[John_w]

I tried this and I get an error invalid procedure Opencomm, even though it clearly is there. Could this be a reference issue?

What is Opencomm? The code doesn't call Opencomm, so it can't be a reference issue.

 

[James Turner]

I'm very sorry...I mentioned the wrong error message.
The error occurs here : Open"com5 , 2400,N,1,...."
Error File not found.

Sorry for the confusion.

 

[John_w]

Does the computer have a COM5 port? If not, try changing the COM5 part to a different port.

 

[James Turner]

It is using Com 5. I verified this. I don't suppose I am missing a reference? I was under the impression this was direct read from the com port.

 

[John_w]

Yes, the code in http://www.mrexcel.com/forum/excel-questions/488335-receive-data-com-port.html#post2410919 is reading COM5 directly. Instead of VBA, try using Hyperterminal as the receiver to see if the data on COM5 can be read.

 

[tvining]

Is there a way I could, after opening the Com Port, Send a line feed and then "Loop 1" to the Comm Port?

 

[Toner]

Hello everybody,

first of all, thx to all people that helps other to learn how things works

I have a question regarding the code in Post 2. since i need to do a similar recording like Harry Geda, i found this forum and his helpfull topics. so i tooked the code and after a little bit of playing with virtual ports and other smaller problems, i got the code work for me without any debug or path errors. but now... my problem... how can i get the received data stored in a xlsx file? should this already work with this code? if yes, where is the file?

My situation looks as follows:
Excel 2013 on Win7
made a new file called Book1.xlsm / xlsx on desktop
put in the code in a Module 1
paired COM3 and COM4 with virtual serial port driver v8.0
Writing data with com port data emulator & Traffic generator on Port 3
VBA Code opens port 4

I know that data is going to port 4 because i see that in the virtualization software and i double checked it with a other Programm (data logger suite)
and the virtualization software also tells me that port 4 is open when i start the vba code. but i cant see any data.

i'll hope that i provided you with all the needet information and that someone could help

thx all