locked
[Excel VB][RS232 communication using Win32comm.bas] RRS feed

  • Question

  • Hi,

    I'm trying to communicate with Modbus RS232/RS485 supported device with the following information

    via my PC using VBA in Excel 2003.

    Modbus Address : 2

    Baud Rate : 9600

    Format : 8-E-1

    Device's Address to Read : 16#0C81

    Device's Address to Write : 16#2135

    I got few samples using win32comm.bas but used in different way.

    can anyone help please? : (

    Thank you in advance

    Young



    • Edited by Young_Nyx Thursday, June 7, 2012 8:42 AM
    Thursday, June 7, 2012 8:40 AM

All replies

  • Hi,

    I'm trying to communicate with Modbus RS232/RS485 supported device with the following information

    via my PC using VBA in Excel 2003.

    Modbus Address : 2

    Baud Rate : 9600

    Format : 8-E-1

    Device's Address to Read : 16#0C81

    Device's Address to Write : 16#2135

    I got few samples using win32comm.bas but used in different way.

    can anyone help please? : (

    Thank you in advance

    Young



    With RS232, there are com ports, there no device addresses. Have you tried talking to the instrument using a program like Hyperterminal?

    After you are able to establish communication, then and only then, can you begin to think about automating the process with VBA.

    Monday, June 11, 2012 1:22 PM