Thanks for the help on previous topic about serial logger data to excel
directly.

i just write and test a basic Visual Basic program for serial port
communication, i make a loop-back circuit on my computer COM 1 (9-pin)
serial port so i can type whatever from the keyboard and return to the same
serial port and display on the program window. the program is working, so i
am thinking next project: write a Visual Basic program to collect
information from a PIC and send the data to some kinda application
software(excel, access...) and automatic creat a plotting graphic in real
time(or maybe every 30 seconds). i don't know what is the simple and easy
way to work on this project. can someone direct me to finish this project,
any tip, code, website, or book?
thanks!!

ps. it does not have to use excel.  at the beginning i was thinking excel
could be the easy one to plot the data

here i attach my simple VB code for the serial port communication:
*************************************************************
*************************************************************

Private Sub Command1_Click()
    End                                   'exit
End Sub

Private Sub Form_Load()
MSComm1.CommPort = 1                     'com port = 1
MSComm1.Settings = "9600,N,8,1"
MSComm1.InputLen = 0
MSComm1.PortOpen = True
MSComm1.RThreshold = 1
'MSComm1.InputMode = comInputModeText
End Sub

Private Sub Text1_KeyPress(KeyAscii As Integer) 'text1 box show the key
input from key board
Dim TempAscii As String
TempAscii = KeyAscii
MSComm1.Output = TempAscii                        'send it to serial port
End Sub


Private Sub MSComm1_OnComm()                   'read the input and display
on text2 box
Dim Buffer As Long
If (MSComm1.CommEvent = comEvReceive) Then
Buffer = MSComm1.Input

Debug.Print "Receive - " & StrConv(Buffer, vbUnicode)
Text2.Text = Text2.Text & Chr$(Buffer)
End If
End Sub
**************************************************
**************************************************

_________________________________________________________________
Take advantage of our limited-time introductory offer for dial-up Internet
access. http://join.msn.com/?page=dept/dialup

--
http://www.piclist.com hint: The list server can filter out subtopics
(like ads or off topics) for you. See http://www.piclist.com/#topics