limiboomer

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. I have tried using the above VBA code to read from a serial port and it works very well but with one small issue: If there is no incoming data, or less data than RecLen, then the 'Get' statement locks up until there is more data available. Download Free Fundamentals Of Esthetics Rufenacht Pdf Writer more.

I have also tried changing to 'binary' instead of 'random' for the filemode so I can read one byte at a time but still have the same problem. Is there some way of checking if there is incoming data available before calling 'get' (eg like the 'kbhit' function in C) or alternatively some way of making the 'get' function time out if it doesn't return within a certain time? [QUOTE=John_w;3548242]That code is all you need to answer the specific question asked by the OP, but your situation might be different. I must thank for this info and code - it has get me close to my solution). Excaktly as you i have excel2003 and runs this in makro.

I hope to catch info from an attached GPS in COM18 sending NMEAcodes. Igo Navigation Software Australia Day. BUT do you have any idea why the code above just finds blank/empty records? So the code doesnt comes in to the central parts. I have tested to take out my GPS and it works just the same way! Also when i change the code to a comport that doesn exist it behavse the same! Why doesnt i hook on the signals at all??

Do you have any idea och thoughts it would be lovely! Fake Parking Ticket Pdf Ukuran. The gps is a bu353 and have a programproduct sent along with it which is working fine and shows the COM18 code in a window rolling over ghe screen. So there is a signal in the port! Ingvar Sweden.

Mar 31, 2017 USB Communication with MS Excel - Page 1. Err.Description End With Resume Routine Serial Port Communication in Excel. Introduction to Serial Port Communication.lngErrorCode = lngStatus.strFunction = 'CommOpen'.strErrorMessage = Err.Description End With Resume Routine Ethernet Arduino and USB-to-serial. This course examines the revolutionary developments in painting, sculptural and architectural traditions from the 19th C. Government Relations The SBE is an advocate.