The Measure Serial Control User Manual describes how to install, set up, and use the Measure Serial Add-In for controlling serial instruments. This manual gives you specific information about using the Serial Add-In with Microsoft Excel.
Deflicker Software Final Cut Pro. 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. 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. 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! 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.
I don't usually set the cell number format before passing the data, I do it at the same time, something like: With Sheet1 Cells(j + 1, i + 1)= Format(objRs.Fields(i).Value, 'mm-dd-yyy') End With It sets the correct format and correct value. In essence you wouldn't need this anymore:.Range('F1:F' & objRs.RecordCount + 1).NumberFormat = 'dd-mm-yyyy'.Range('G1:G' & objRs.RecordCount + 1).NumberFormat = 'dd-mm-yyyy' Also, I would check what is the data type of the date field you're trying to pass, it may shade more light on this. Best of luck.
The problem was fixed by using below syntax With oSheet For i = 0 To objRs.Fields.Count - 1.Cells(1, i + 1).Value = objRs. Teenage Mutant Ninja Turtles 2003 Download Full Pc Game Tpb. Fields(i).Name objRs.MoveFirst For j = 1 To objRs.RecordCount If i = 5 Or i = 6 Then.Cells(j + 1, i + 1) = Format(objRs.Fields(i).Value, 'dd-mmm-yyyy') 'oSheet.Cells(j + 1, i + 1).Value = objRs.Fields(i).Value Else oSheet.Cells(j + 1, i + 1).Value = objRs.Fields(i).Value End If objRs. Gemvision Countersketch Studio Rapidshare on this page. MoveNext Next Next.Range('F1:F' & objRs.RecordCount + 1).NumberFormat = 'dd-mm-yyyy'.Range('G1:G' & objRs.RecordCount + 1).NumberFormat = 'dd-mm-yyyy' End With Thank you very much D-niss. User-Defined Date/Time Formats (Format Function) The following table identifies characters you can use to create user-defined date/time formats: Character Description ( Time separator. In some locales, other characters may be used to represent the time separator. The time separator separates hours, minutes, and seconds when time values are formatted. The actual character used as the time separator in formatted output is determined by your system settings.