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.

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.

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.