1,105,232 Community Members

How to read from serial port into excel

Member Avatar
Hotshottech
Newbie Poster
2 posts since Aug 2006
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Is there a code in VBA that will read data from a RS232 port and import it into the selected cell in excel or can I buy a program that will work.

Member Avatar
Comatose
Taboo Programmer
2,536 posts since Dec 2004
Reputation Points: 290 [?]
Q&As Helped to Solve: 227 [?]
Skill Endorsements: 34 [?]
Team Colleague
 
0
 

There was a day when I'd say yes. As of right now, we have a few hot threads about this....(not about excel, but about reading from a serial (or parallel) port with V6:
http://www.daniweb.com/techtalkforums/thread52807.html
http://www.daniweb.com/techtalkforums/thread52505.html
http://www.lvr.com/parport.htm#Programming

Basically, it looks as though in XP we have to try to use this new DLL, but it's giving problems to some people. If you can get it to work, it's easy enough to port the data to excel.

Member Avatar
BombAppetit
Light Poster
29 posts since Jun 2006
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
1
 

if we are to write through the comm port, how do we do it in HEX? for PIC programming purposes is VBA able to do it (access/excel)

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article