Problem scenario: I would to receive my data from a RS232 (COM) port and send this data to Microsoft Excel for further processing and analyzing. Requirements:.

• Excel Serial Communication Example

Feb 20, 2009. The Win32 API handles the serial port as a file. You can access the serial ports directly by calling these API functions from within VBA. I had to do this for an old.NET application but VBA is no different. Rather than hash it out for you on this site, here's a reference I've hung onto over the years. In addition, they learn Visual Basic (building on their programming skills developed in the C++. Serial port communication with VBA. Communicating with the RS-232 port (the “COM” port) in VBA is fundamental to instrument communication. Many simple devices, such as balances, thermocouple meters, and data.

Professional, Enterprise or Trial version;. Several plug-ins for this software. It is assumed that: You've configured communication parameters (baud rate, number of data bits, flow control etc) in the data logger and can receive any data without communication errors. Solution: Our software allows you to send your data from RS232 (COM port) to Excel in followings ways: Connect RS232 to Excel with help of the Local database plug-in Advantages:. Doesn't require to install Excel on the production PC;.

Can create Excel files in background. Disadvantages:. Re-creates an Excel file every time and therefore requires rather more PC resources if your data flow is fast;. Unable to export data from several RS232 port to one file.

Read about this method. Link RS232 to Excel with help of the Direct Excel connection plug-in Advantages:. Allows you to place parsed data to any columns and rows;. Is very useful if you want to watch your RS232 data in a real time environment.

Disadvantages:. Requires Excel on the production PC, if you'll add charts and formulas to an Excel files, then this link will be very slow. Read about this method.

Send data from RS232 to Excel with help of the DDE interface Advantages:. Allows you to place parsed data to any columns and rows;. Is very useful if you want to watch your RS232 data in a real time environment;. Excel automatically starts the data logger software;. Allows to use the data logger on a remote PC (DDE over network is used in this case);. Allows you to process data from RS232 in Excel with help of VBA code.

Disadvantages:. Requires Excel on the production PC, if you'll add charts and formulas to an Excel files, then this link will be very slow;. Requires small VBA knowledge.

Read about this method. Receive data from RS232 to Excel with help of our ActiveX control Advantages:. Allows you to process data as you want;. Allows you to receive unparsed binary RAW data from RS232 to Excel;. Allows you to receive notifications about program events;. Allows you to send data from Excel to RS232;. Excel automatically starts the data logger software;.

Is very useful if you want to watch your RS232 data in a real time environment. Allows you to process data from RS232 in Excel with help of VBA code.

Disadvantages:. Requires Excel on the production PC;. Requires deep VBA knowledge;. ActiveX control isn't free and requires an additional license. Necessary ActiveX control from our site. An example and the help file comes will be installed with the ActiveX control.

Excel Serial Communication Example

Related articles:.

I have neen doing it for several years now. I have seen three methods: 1 - MSCOMM 2 - Common Basic statements of OPEN, PRINT/WRITE, CLOSE and 3 - The method I use, API calls into the Kernel32.

I am using Excel 97 and it will not run MSCOMM. Something about not being licenced or approved. I don't recall the exact wording of the message I got when trying to load the MSCOMM module. I can send you workbooks that have methods 2 & 3. I have seen MSCOMM examples on the web as well. They may be large!!

They send out the port to operate ham radios and are quite envolved, but you should be able to use the module. My method has one module with very good comments and was written by someone who knew what he was doing.