Using ActiveXperts Serial Port Component with VBA (Visual Basic for Applications) ActiveXperts Serial Port Component is a software development kit (SDK) that enables the user to communicate to a device over a serial interface. This topic describes how to use My.Computer.Ports to receive strings from the computer's serial ports in Visual Basic. Determine which serial port should provide the strings. This example assumes it is COM1. Use the My.Computer.Ports.OpenSerialPort method to obtain a reference to the port.

I need to create a button in Excel to read data in from serial port. I can't have any extra files attached to the excel sheet. I need to transfer this excel file to another computer to read this data. Here is how the file is suppose to function: Press button to select the serial port. Then, press another button to read data from serial port into the excel cell. Could someone please tell me how to do this? Use VB macro or ActiveX macro? Sorry, this is the first time i'm using excel for this. Help please. Again, I can't have another file attached to the excel sheet. Thank you!

1 Answer

I found a discussion on exactly this topic in the german microcontroler.net forum here:

Since I am running on Linux I can not verify if the code is correct. Anyway, here is a copy of it:

Vba Serial Port Monitor

Not the answer you're looking for? Browse other questions tagged vbaexcel-vbaserial-portarduinoexcel or ask your own question.

Excel Vba Serial Port Communication

Explore this ArticleInstall Software (Establish RS232 & DDE Communication)Bill Redirect Software (General Configuration)Bill Redirect Software (RS232 Serial Port configuration)Microsoft Excel (General Configuration)Excel Plugin ConfigurationSeveral Option Are AvailableShow 3 more...Show less...Ask a QuestionRelated ArticlesReferences

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!