469,883 Members | 1,231 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,883 developers. It's quick & easy.

Open / Operating Serial Communication Port

I have a small project, which need use both RS232 port and
excel for data plot. I considering use excel VB macro for
the entire project.

Although I used serial port extensively in MFC, I am not
sure how to open serial port from VB. Can anyone give me
a little light?

Really appreciated,

Ben Zhu
Nov 20 '05 #1
4 15618
Ben,
You can use MSCOMM.OCX if you have VB6 loaded on your machine.

Alternative there are 2 samples on www.gotdotnet.com that supports Serial
communication.

http://www.gotdotnet.com/Community/U...x?query=serial

I've look at the first two listed (from corcav & LoMan).

Hope this helps
Jay

"Ben Zhu" <bz**@revivant.com> wrote in message
news:07****************************@phx.gbl...
I have a small project, which need use both RS232 port and
excel for data plot. I considering use excel VB macro for
the entire project.

Although I used serial port extensively in MFC, I am not
sure how to open serial port from VB. Can anyone give me
a little light?

Really appreciated,

Ben Zhu

Nov 20 '05 #2
Hello,

"Ben Zhu" <bz**@revivant.com> schrieb:
I have a small project, which need use both RS232 port and
excel for data plot. I considering use excel VB macro for
the entire project.


Thomas Scheidegger's Serial Port FAQ:

http://tinyurl.com/aawh

--
Herfried K. Wagner
MVP VB Classic, VB.NET
http://www.mvps.org/dotnet
Nov 20 '05 #3
Hi,

Actually, this sounds like an Excel VBA question, not VB .NET? In either
case, you can download NETComm.ocx from my homepage. It works fine in
Excel, even though I designed it as an easy way to do serial IO in .NET.

Dick

--
Richard Grier (Microsoft Visual Basic MVP)

See www.hardandsoftware.net for contact information.

Author of Visual Basic Programmer's Guide to Serial Communications, 3rd
Edition ISBN 1-890422-27-4 (391 pages) published February 2002.
Nov 20 '05 #4
VBA in Excel does not support serial communications without either
writing some very complex code that calls Windows API functions
directly or using a serial communications tool provided by a third
party vendor.
If you have VB6, you can use the MSComm32.OCX ActiveX control however
it is not very easy to use in Excel.
You may want to look at a product called WinWedge at www.taltech.com
WinWedge is designed to make it extremely easy to send and receive
serial data directly from within other programs like Excel, Access or
just about any other Windows program. WinWedge can save you countless
hours of serial I/O coding and it works great with Excel.
On Tue, 9 Sep 2003 16:59:23 -0700, "Ben Zhu" <bz**@revivant.com>
wrote:
I have a small project, which need use both RS232 port and
excel for data plot. I considering use excel VB macro for
the entire project.

Although I used serial port extensively in MFC, I am not
sure how to open serial port from VB. Can anyone give me
a little light?

Really appreciated,

Ben Zhu


Nov 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by mimisam | last post: by
1 post views Thread by Andreas Horneff | last post: by
7 posts views Thread by Michael Chong | last post: by
6 posts views Thread by Leandro Berti via DotNetMonster.com | last post: by
4 posts views Thread by max_mont | last post: by
reply views Thread by Dhananjay | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.