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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Pat Adams

    I need help reading/writing to the registry

    Pat Adams, Nov 29, 2003, in forum: Word VBA Beginners
    Replies:
    2
    Views:
    125
    Pat Adams
    Nov 29, 2003
  2. gravesen
    Replies:
    1
    Views:
    144
    Perry
    Sep 19, 2004
  3. Nick Calladine

    Reading Value From Form Field Dropdown Box

    Nick Calladine, Aug 26, 2005, in forum: Word VBA Beginners
    Replies:
    4
    Views:
    112
    Nick Calladine
    Aug 27, 2005
  4. Nick Calladine

    reading formfields in a table

    Nick Calladine, Sep 17, 2005, in forum: Word VBA Beginners
    Replies:
    3
    Views:
    190
    Greg Maxey
    Sep 17, 2005
  5. Robert Secon

    reading line from table cell into array

    Robert Secon, Sep 19, 2005, in forum: Word VBA Beginners
    Replies:
    10
    Views:
    137
  6. KristyS

    Reading items in a list box

    KristyS, Sep 27, 2005, in forum: Word VBA Beginners
    Replies:
    1
    Views:
    73
    KristyS
    Oct 11, 2005
  7. efqwf

    Reading textfile

    efqwf, May 4, 2006, in forum: Word VBA Beginners
    Replies:
    1
    Views:
    70
    Cindy M -WordMVP-
    May 5, 2006
  8. Cash

    Reading from DB to Array/Variable

    Cash, Oct 30, 2006, in forum: Word VBA Beginners
    Replies:
    1
    Views:
    79
    Jezebel
    Oct 30, 2006
Loading...