MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to store data into Excel read from a serial port?

Posted by Dave Engelken on October 23, 2001 3:22 PM

Is there a way in Excel to read data from a serial port
console (e.g. hyper term) and stuff the data into a
cell in Excel?

We need to do something like this for my son's Cub
Scout Pinewood Derby race.
The times for the cars will be put on a hyperterm by
a sensor. I want to have Excel read that data and
stuff it into a cell.

Can anyone help me on this?

BTW, I am a Software Engineer.



Posted by Mark W. on October 24, 2001 6:09 AM

I immediately thought of National Instruments
LabVIEW and started poking around with a web
search engine. These URLs seem interesting...

I'm guessing that logging to a text file and
then opening it in Excel to perform your analysis
isn't sufficient. Right?