Dear Chen, I don't have anything that does exactly that but I do have a rough VB program for receiving rs232 from a pic. I use it for testing. I'm sure you could adapt it. As for getting it into Excel you can use DDE. This is a very old standard but is still supported. In my opinion it is much simpler and reliable than OLE automation. I do it with Word a lot. If you look hard you can find some good info on the web. Look for terms like DDEPoke & DDEExecute. The other thing you can do which is probably even easier is to get VB to output text in html format and the name the file with a .xls extension. Excel will open it like an ordinary .xls file. I have some code for that too. Let me know if you want the VB code. Regards, Lee. ----- Original Message ----- From: "jay chen" To: Sent: Wednesday, January 07, 2004 8:30 PM Subject: Help! Serial Logger Data to Excel directly > Hi, > Has anyone written a simple Visual Basic program that will enable serial > data to be read directly into Excel that they are willing to share? I want > to try with a simple PIC data logger and read the serial data directly into > Excel. or any suggests website or book, which can help me to finish this > project!! > Thanks !! > > chen > > _________________________________________________________________ > Check your PC for viruses with the FREE McAfee online computer scan. > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > -- > http://www.piclist.com hint: PICList Posts must start with ONE topic: > [PIC]:,[SX]:,[AVR]: ->uP ONLY! [EE]:,[OT]: ->Other [BUY]:,[AD]: ->Ads -- http://www.piclist.com hint: PICList Posts must start with ONE topic: [PIC]:,[SX]:,[AVR]: ->uP ONLY! [EE]:,[OT]: ->Other [BUY]:,[AD]: ->Ads