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.
Hotshottech 0 Newbie Poster
Comatose 290 Taboo Programmer Team Colleague
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.
BombAppetit 0 Light Poster
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)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.