Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default can com port data be imported & sorted into cells?

I have an external device that is tracking ID's for radio traffic. It sends
out a 4 or 5 number ID to Com port 1 (9600,N,8,1). I would like it to
automatically log, sort the data (last digit is a status bit), and time/date
stamp the entry. is this possible?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default can com port data be imported & sorted into cells?

Here are some snippets copied from previous messaged related to using the
serial port:

The best way to do it is to use the MSComm control that comes with Visual
Basic. If you want to see how this works, load and single step through the
VBTerm sample that comes with it (should be in the \samples subdirectory; if
not, I think you can download it from Microsoft's Visual Basic site).

One important note, though, is that you must know the syntax of the commands
to your meter (or other device), as sent via RS-232. Once you know those
you can simply modify the VBTerm code to suit your own purposes. It's
complex at first, but stick with it!


"Poor Man's Serial Instant Messenger"
http://www.htservices.com/Tools/Visu...unications.htm
Visual Basic Serial Communications Example Tutorials Source Code Programs


http://www.cpcug.org/user/clemenzi/t...s/SerialIO.htm
Serial I/O (RS232)

http://www.yes-tele.com/mscomm.html - MSComm

--
Regards,
Tom Ogilvy


"Radioz" wrote in message
...
I have an external device that is tracking ID's for radio traffic. It

sends
out a 4 or 5 number ID to Com port 1 (9600,N,8,1). I would like it to
automatically log, sort the data (last digit is a status bit), and

time/date
stamp the entry. is this possible?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks not moving with cells when data is sorted Marina Excel Worksheet Functions 0 February 4th 10 01:08 AM
Format Cells Date (or any change) not working on imported data [email protected] Excel Discussion (Misc queries) 1 February 8th 08 12:24 PM
Change the right click menu on cells with imported data? Beth Trainer Excel Worksheet Functions 0 December 8th 05 06:43 PM
Capturing Data from a Com Port or Printer Port Newby :) Excel Programming 3 August 19th 05 01:54 PM
Receiving data from a Lan Port Ste[_3_] Excel Programming 0 March 1st 05 11:31 AM


All times are GMT +1. The time now is 01:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"