How to Read RS232 to Excel Macro VBA Data Acquisition

Step-by-Step Guide

1. 1

   Step 1: Download and install Bill Redirect software: http://www.billproduction.com/Bill_COMtoKB.ZIP.

   This software is used to establish the communication with your RS-232 COM Port device .
2. 2

   Step 2: Download and install the Excel plugin.

   This is at http://www.billproduction.com plugin_DDE.zip.
   
   This plugin software is used to establish the communication with Microsoft Excel via DDE , The default password to edit the configuration is: www.billproduction.com. , In section "Serial Port" set the switch to:
   On.
   
   In section "Plugin" set the switch to:
   On. ,, If the background color is green, it means that the serial port works and the port is open.
   
   Select the Bauds, Parity and Databits configured in your device. ,, This solution is compatible with all Excel version and language ! ,,,, The default password to edit the configuration is: www.billproduction.com.
   
   Important:
   The TCP Connection Status must indicate:
   Connect.
   
   If it is not to Connect then make sure that Bill Redirect Software is open.
   
   In trial mode you must restart the software Bill Redirect after each 15 minutes to continue your test."
   
   If all is okay, the DDE Connection Status indicate:
   Connect.
   
   At this point the communication is establish with your Device via Excel.
   
   The data received from your device is sent in Excel. , Use the button:
   Test DDE.
   
   To see what your device sends or receive, use the section Debugger in Bill Redirect. ,,,{ASCII:13} by the command you want.
   
   Supplemental documentation.
   
   Excel Plugin full manual with all explanation: http://www.billproduction.com /Bill_DDE_over_Ethernet.pdf.
   
   Bill Redirect Software full manual with all command:http://www.billproduction.com /Bill_Redirect_Manual.pdf.
3. 3

   Step 3: Start the software: Bill Redirect.

4. 4

   Step 4: Disable all section except the Serial Port and Plugin.

5. 5

   Step 5: Click on: Serial Port Configuration.

6. 6

   Step 6: Enter the Serial Port Number where your device is connected.

7. 7

   Step 7: Click on button: Save Configuration If you use a RS-232 to USB converter to connect your device on the computer

8. 8

   Step 8: it is important to use a converter with FTDI chipset for a good stability !

9. 9

   Step 9: Start: Microsoft Excel .

10. 10

    Step 10: Create a in Excel a: new blank document.

11. 11

    Step 11: Make sure that the sheet name is: Sheet1.

12. 12

    Step 12: Save your Excel document to: C:\BillProduction.CFG\MyFile.xlsx.

13. 13

    Step 13: Start the Excel Plugin .

14. 14

    Step 14: In the Excel Plugin click on the folder icon and select your Excel File created at step before.

15. 15

    Step 15: Test your communication with Excel.

16. 16

    Step 16: Consider example #1:' Call an Excel Macro after each data received: Simply enter your macro name in the field "Run macro:" To test the call of your macro use the button at right.

17. 17

    Step 17: Consider example #2:' Send a command to your device via VBA:

18. 18

    Step 18: To send data command from Excel to your device use this VBA Excel source code: ChannelNumber = DDEInitiate("BPEXCEL"

19. 19

    Step 19: "BPEXCEL") DDEExecute ChannelNumber

20. 20

    Step 20: "{TX_SERIAL}" DDETerminate ChannelNumber Replace the command Hello Word !

Detailed Guide

About the Author