Reading virtual COM port and import data in Excel

T

test

I want to make a device that gathers data and log it.

It's a portable device that I can connect via USB and make it talk to
the PC via a COM port (tried it with a terminal program).

I'm not that good with programming, so thats why I decided to ask you
all.

Is there a way to get Windows look if the COM port is present, then
send a signal that it is ready to recieve data, gather the data and if
this was succesful, send another signal to the device that all data
was received?

If this is possible I want it directly to work in Excel.
So if the Excel sheet is opened, and a user clicks on a button, it
checks if the COM port is present, sends a signal that the PC side is
ready, gather the data that the device sends, after receiving, sends
another signal that the data can be flushed from the internal memory
of the device.

Is this daydreaming, or can this be done?
Any help is welcome!

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top