[Elbatrop1]

Hey everyone. I've never used Visual Basic before, so forgive me if I sound dumb.

I've been told that Vis Bas would probably the best programming software to use for this application.

I'm doing a project for school, which involves inputting raw rs232 data into the serial port. I have no problem getting the data into regular rs232 format (start &stop bits, +10V,-10V, baud rate, etc). I would like the final result to be put into ms excel, and graphed. But what i dont know is everything in between the serial port and the excel spreadsheet. Could you guys help me out?

Thanks!

[raylu]

First off, I've never done this before.

OLE
That should be your answer.
If you told me what the project was, a short little description, I may be able to help.

You could also yous the VBX that comes with Excel.

[willer]

---------------------------------------------------
I have no problem getting the data into regular rs232 format (start &stop bits, +10V,-10V, baud rate, etc)....????
---------------------------------------------------

Private Sub Comm_OnComm()

'Comm.Input is the input data from another socket
stat.Caption = stat.Caption & Comm.Input
End Sub

Private Sub Form_Load()

Comm.CommPort = 2

' Set the port number
Comm.Settings = "9600,N,8,1"
' you may not need to set anything for direct cable
' Tell the control to read entire buffer when Input is used
Comm.InputLen = 0
Comm.RThreshold = 1

' Open the port.
Comm.InBufferSize = 1024
Comm.PortOpen = True

End Sub

Private Sub ping_timer_Timer()

'Comm.Output - This timer will send out something every few second
Comm.Output = "Ping from port" & Comm.CommPort & " - " & Now
End Sub

--------------------------------------------------------
i dun know u oledi know "how to send/get data "

[willer]

i saw the "save data to excel spreadsheet" tutorial b4 , but i forgoten where the URL was... u can find it

but if u need save to some file that can be open by excel, why dun try *.CSV file , a simple comma separate data file, text base
no need extra COM object loading

[willer]

u need a direct cable for comm...
here is the wiring
http://support.microsoft.com/default...NoWebContent=1

i just built one last month , just RM 8, (2Xrs232 socket + CAT cable+15 minutes)

[willer]

if need more resource , goto MSDN, there is where i start VisualBasic.