Reading virtual COM port and import data in Excel

Discussion in 'Word VBA Beginners' started by test@testnospam.nl, Jul 28, 2010.

  1. Guest

    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!
     
    , Jul 28, 2010
    #1
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.