How.com.vn is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, 13 people, some anonymous, worked to edit and improve it over time.
This article has been viewed 34,831 times.
This tutorial explains how to establish a bidirectional real-time communication between Microsoft Excel and your RS232 COM Port devices like a Scale, Proximity reader, Barcode reader, temperature sensor, Caliper, Micrometer, Gage. This solution uses the software "Bill Redirect" with the "Excel Plugin" to easily connect your peripheral and receive and send the data. The communication between Microsoft Excel and your device is made via a direct DDE link. An Excel Macro can be called after each data received from your device to validate the data received. This solution explains how you can send a command via VBA to your device and totally control your device. No programming or additional hardware required!
Steps
Install Software (Establish RS232 & DDE Communication)
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 .
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 DDEAdvertisement
Bill Redirect Software (General Configuration)
Bill Redirect Software (RS232 Serial Port configuration)
Click on: Serial Port Configuration.
Enter the Serial Port Number where your device is connected.- 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.
- If the background color is green, it means that the serial port works and the port is open.
Click on button: Save Configuration- If you use a RS-232 to USB converter to connect your device on the computer, it is important to use a converter with FTDI chipset for a good stability !
Advertisement
Microsoft Excel (General Configuration)
Excel Plugin Configuration
Start the Excel Plugin
. 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."
In the Excel Plugin click on the folder icon and select your Excel File created at step before.- 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.
Test your communication with Excel. Use the button: Test DDE. To see what your device sends or receive, use the section Debugger in Bill Redirect.Advertisement
Several Option Are Available
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.
Consider example #2:' Send a command to your device via VBA:
To send data command from Excel to your device use this VBA Excel source code:- ChannelNumber = DDEInitiate("BPEXCEL", "BPEXCEL")
- DDEExecute ChannelNumber, "{TX_SERIAL[Hello Word !{ASCII:13}]}"
- DDETerminate ChannelNumber
- Replace the command Hello Word !{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.
Advertisement
Expert Q&A
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
