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:

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)

This article has been dead for over six months. Start a new discussion instead.