EXCEL 2007 / RS 232

[Christian Lehmann]

Hallo,

on my computer I run the German version of EXCEL 2007 together with Windows
XP Pro / SP2. I would like to use RS 232 to copy data from measurement
instruments to EXCEL sheets.

I am familiar with VBA and C++, however, I do not have any knowledige on RS
232 programming:

- my most favourite approach would be a fully functional source code which
I could use as an example and which I can adapt to my needs. Could be a VBA
source code or a DLL / XLL which runs together with EXCEL 2007.

- second option would be a book or any suitable web page that I could use to
learn RS 232 programming.

Thank you for any suggestion!

Best regards,
Christian Lehmann

 

[Niek Otten]

Hi Christian,

A Google search for "excel" and "rs232" gives thousands of hits.

Here's one:

http://www.windmill.co.uk/rs232.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hallo,
|
| on my computer I run the German version of EXCEL 2007 together with Windows
| XP Pro / SP2. I would like to use RS 232 to copy data from measurement
| instruments to EXCEL sheets.
|
| I am familiar with VBA and C++, however, I do not have any knowledige on RS
| 232 programming:
|
| - my most favourite approach would be a fully functional source code which
| I could use as an example and which I can adapt to my needs. Could be a VBA
| source code or a DLL / XLL which runs together with EXCEL 2007.
|
| - second option would be a book or any suitable web page that I could use to
| learn RS 232 programming.
|
| Thank you for any suggestion!
|
| Best regards,
| Christian Lehmann
|
|

 

[Thomas Lutz]

The quickest and easiest way to get data from RS232 devices directly
into Excel is to use a 3rd party tool like WinWedge from:
www.TALtech.com

Excel does not provide direct support for RS232 communications however
you can use the VBA macro language in Excel to write code that reads
in data from a serial port. Unfortunately the code is fairly complex
to implement and it does not give you real event-driven I/O. Another
way to do things is to use a good serial communications ActiveX
control like the MSComm control that comes with Visual Studio 6 (or an
equivalent serial communications ActiveX) ActiveX controls would be
much simpler to use although you still have to write a little code.