473,545 Members | 1,164 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 15816
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
5426
by: mimisam | last post by:
hi, I am using Win XP and writing an application to check POS devices (printer and cash drawer).In the application I need to choose the port which the device is connected to. If the port chosen is wrong or the device is off power, a communication error message should be displayed. I am using FileOutputStream and FileInputStream to send and...
1
8802
by: Andreas Horneff | last post by:
Hi @ all, I've got a problem with serial communication in Borland C++ Builder. I've already found a lot of stuff about serial communication in the internet, but it dosen't work. What I want to do: I want to connect only one button to my com port. If the button is pressed,
11
7059
by: sarah | last post by:
hI, I have a project. I need to realise serial communication between PC and Altera FPGA in c or c++. The function of FPGA is working well. it can send data to uart. Does anybody know how to realise it in c or c++? Thanks
7
2741
by: Michael Chong | last post by:
I wrote a program that communicate with SerialComm. In every 300 milliseconds, my program continuously send & receive data via the serial port once the program starts. My program is once in a while, the serial port seems corrupted because when my data is sent, it doesn't go through the serial port, so as same to receive process. In order to...
6
2841
by: Leandro Berti via DotNetMonster.com | last post by:
Hi All, I wrote a code to do serial communication with an equipament. When i use the code outside of threaded class it seens work properly, but when i put inside a class and execute a thread in the first seconds the communication is ok, later i receive read/write error. I?ve been in MSDN site and there i discover that the read/write error...
4
11164
by: joe bloggs | last post by:
I am writing a mobile application to interface with a legacy system and I am planning to use web services to communicate with this system. The legacy system receives data through a serial port. What I would like to do is make the serial port accessible via a web service. The web service and the legacy application would be running on the...
4
4796
by: max_mont | last post by:
Hi all, I'm a newbie in .NET technology. I've already developed Serial communication applications in C++ (WIN32). And I wanted to migrate to .NET technology. There is a serial component in framework to read and write on serial port. I would like to make asynchronous reception. I saw that we can pass a delegate to the serial class which is...
2
8250
by: Adrian Chen | last post by:
please help me! I come across a problem. Now I develop a finger print management system which is based on B/S.When users click a button in the web pages, a device connected to the COM1 serial port of the client machine starts to work. Now I wrote the code which is in charge of serial communication in the ..aspx.cx pages, but then I found that...
0
2895
by: Dhananjay | last post by:
Hi, I am working on an VB.Net application which I want to communicate to external device using comm port (Serial Port) . So for that first I am trying to simulate the communication on serial port between two computers using HYper terminal on both the machines. Both these computers are connected on serial port using DB9(f) null modem...
0
7467
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7401
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7807
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7419
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7756
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5971
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5326
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
1
1879
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
703
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.