How we can access com port and display data from com port usin Microsoft Excel

 

I don't believe Excel will input a file from the COM port, but a comma delineated text file transferred into the computer can be read and understood by the application. Just recall which folder has the file and open it with Excel.

 

You can add Visual Basic code to Excel sheets. Use that to interface with the computer's serial port.

Won't be easy afaik, because you don't have direct access to the ports in XP/Vista and need extra software for that.

 

Hi,
This is possible. The thing you should do is to know how to use ODBC Control in VB. After creating ODBC link, you can store any data to Excel even from Serial port.

Visit this link and Get more details of it:
http://www.bigresource.com/VB-plotting-data-from-serial-port-in-visual-basic-6-0-8WTWT8R2Eo.html

I will post a Story about this on my blog soon, so visit my blog without forgetting.

 

B&B Electronics makes some low cost serial bus DAQ modules that give you delimited data. Once you have that it's a snap to import it into Excel

eric

 

http://www.selmaware.com/selmaDAQ/home.htm

 

What you have given is a Complete application, that looks after the Serial port but If we need to design the Basic controls of our own wish, we can go for VC++ or VB with ODBC links.

 

How we can access com port and display data from com port usin Microsoft Excel

If I understand correctly, what is needed is to tranfer on an excel sheet some data coming through the serial port. This is not difficult to do if you know visual basic. But you also need to know what kind of string you receive from the serial port, and how you want to order them in the excel sheet.

Alberto