Not to Excel, but I've tied it to Access. Someone mentioned using regular
VB controls for VBA, that's what I did. I had to install VB to get the
development license for MsComm. Then I just added it to a form, set up a
timer to poll the buffer every 100mS and append the data to a string
variable. Whenever my variable exceeds a record length, I run it through a
second function that parses it and appends it to a table.

If I was doing it over again I'd probably use a similar method, but instead
of the timer I'd try to set it up in the OnComm event handler.

I can share if you want (it's not pretty, but it works) but it won't work
for you unless you have a copy of VB for the MsComm license.

I remember reading somewhere someone had wrapped MsComm and released it
freeware, so you could probably find an alternative.

-Denny


> 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