Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Importing real-time data into Excel using com4

by naivegeye Feb 25, 2008 2:07AM PST

Does anyone know how to import data from a timer that uses a USB interface and com4 into Excel? The timer is an Ultrak 499 with the USB connector. According to the instructions it uses Com 4.

I am trying to get the information to update an Excel cell real-time. I believe the timer sends a text string of the time when the lap button is pressed. This time is what I am trying to capture. Any suggestions would be greatly appreciated.

Thank you.

Will

Discussion is locked

3 Posts

- Collapse + Expand Details

- Collapse -

National Instruments.

by r. proffitt Forum moderator Feb 25, 2008 2:11AM PST

A long time ago I used a plugin from them (about 1,200 bucks). Today I just use a VB app that uses a grid element (cheaper and I can install all over!)

Research the LabView offerings.

Bob

- Collapse -

Thanks Bob,

by naivegeye Feb 25, 2008 6:21AM PST

Thanks for the reply. Do you still have any of the code around??

Did you have to use the DOS shell to bring the information into the VB program?

Will

- Collapse -

Reading the serial port in VB6 was easy.

by r. proffitt Forum moderator Feb 25, 2008 7:16AM PST

And the code is all over the internet... Mine would be no better than what you find at krugle.com or other sites.

Bob

Back to Office & Productivity Software forum