RS232 to Excel

Discussion in 'Microsoft Excel Programming' started by John Gittins, Jul 16, 2003.

  1. John Gittins

    John Gittins Guest

    How do I write and receive data from RS232? Does XP cause any problems in
    this?

    --
    John Gittins
    Production Engineer
    SRC Automotive
    4431 West Calhoun
    Springfield
    MO 65810
    Phone 417 829 2411
    Fax 417 829 2427
     
    John Gittins, Jul 16, 2003
    #1
    1. Advertisements

  2. John Gittins

    Tom Ogilvy Guest

    Here is some information previously posted by others in response to similar
    questions.

    The best way to do it is to use the MSComm control that comes with Visual
    Basic. If you want to see how this works, load and single step through the
    VBTerm sample that comes with it (should be in the \samples subdirectory; if
    not, I think you can download it from Microsoft's Visual Basic site).

    One important note, though, is that you must know the syntax of the commands
    to your meter (or other device), as sent via RS-232. Once you know those
    you can simply modify the VBTerm code to suit your own purposes. It's
    complex at first, but stick with it!


    "Poor Man's Serial Instant Messenger"
    http://www.htservices.com/Tools/VisualBasic/SerialCommunications.htm
    Visual Basic Serial Communications Example Tutorials Source Code Programs


    http://www.cpcug.org/user/clemenzi/technical/Languages/SerialIO.htm
    Serial I/O (RS232)



    http://www.allapi.net/vbexamples/list.php?category=SOURCE

    Regards,
    Tom Ogilvy

    "John Gittins" <> wrote in message
    news:...
    > How do I write and receive data from RS232? Does XP cause any problems in
    > this?
    >
    > --
    > John Gittins
    > Production Engineer
    > SRC Automotive
    > 4431 West Calhoun
    > Springfield
    > MO 65810
    > Phone 417 829 2411
    > Fax 417 829 2427
    >
    >
     
    Tom Ogilvy, Jul 16, 2003
    #2
    1. Advertisements

  3. John Gittins

    Thomas Lutz Guest

    If you are looking for a good tool to do serial communications
    directly from within Excel, I would recommend that you look at a
    product called WinWedge at the following URL:
    http://www.taltech.com/TALtech_web/products/winwedge.html

    WinWedge is designed to make it easy to both send and receive serial
    data direclty from within any other Windows program including Excel
    and it requires little or no programming at all.


    On Wed, 16 Jul 2003 10:59:23 -0500, "John Gittins"
    <> wrote:

    >How do I write and receive data from RS232? Does XP cause any problems in
    >this?
     
    Thomas Lutz, Jul 17, 2003
    #3
  4. John Gittins

    bliebb3

    Joined:
    Aug 17, 2009
    Likes Received:
    0
    bliebb3, Aug 17, 2009
    #4
    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.