Chen,

IIRC, you could use VBA with regular VB controls=2E Add the MSCOMM control
to your VBA project and you have very complete serial comms at your
fingertips=2E

I suppose you are collecting statistical values of some sort, in which
case I would use a standalone VB application=2E The app would handle
serial comms and insert values as appropriate into an Access DB=2E The DB
can be read an written to while in use by the VB app=2E Furthermore,
Access has many export capabilities and VBA=2E
Excel isn't really suited nor intended for database type data,
especially if we are talking of large amounts=2E

HTH,

Hugo


>>-----Original Message-----
>>From: pic84chen@HOTMAIL=2ECOM [mailto:pic84chen@HOTMAIL=2ECOM]
>>Sent: Wednesday, January 07, 2004 10:46 AM
>>To: PICLIST@MITVMA=2EMIT=2EEDU
>>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=2E 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=2E
>>http://clinic=2Emcafee=2Ecom/clinic/ibuy/campaign=2Easp?cid=3D3963
>>
>>--
>>http://www=2Epiclist=2Ecom 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