MS Excel ---> <----Visual BAsic Pl Help!!!!!

[bilalbajwa2336]

I want to make a program in visual basic. When i put my salary data in VB (like: Time In , Time Out, DAte, DAy) VB automatically (in the back ground) input this data in the Excel and Show out puts of excel back in Visual Basic (Hours left , Total Hours and Total sALARY). How to do it. My project summary is I want VB to work like a dummy that saves and puts my inputs in Excel and then shows me back the result calculations in excel and finally save that excel file. Please help me and guide. Tell me how to do this. If there are any tutorial that i can modify . Please help. I have no experience in VB. But if u can help me and guide me in right direction.

[Killer42]

I want to make a program in visual basic. When i put my salary data in VB (like: Time In , Time Out, DAte, DAy) VB automatically (in the back ground) input this data in the Excel and Show out puts of excel back in Visual Basic (Hours left , Total Hours and Total sALARY). How to do it. My project summary is I want VB to work like a dummy that saves and puts my inputs in Excel and then shows me back the result calculations in excel and finally save that excel file. Please help me and guide. Tell me how to do this. If there are any tutorial that i can modify . Please help. I have no experience in VB. But if u can help me and guide me in right direction.

Wouldn't it be better to keep it simple and just use Excel?

[bilalbajwa2336]

The thing is when you are working on smart devices. Their small lcd put alot of difficulty for you to put the data in it.
But the purpose of asking for help for this project is alot greater than this. That would a good reference project for me in future. If you wana help then most welcome.

[senthilk111]

hai,
you can do this by using ado connection which establish aconnection between vb and excel. below i have given excel connection string . so using you insert and reterive data as like you access database.

code

Public Function pblfnOpenExcelRecordset(ByVal sFile As String, ByVal strQuery As String) As ADODB.Recordset

On Error GoTo ErrorHandler

Dim rsExcel As ADODB.Recordset
Dim sconn As String
Set rsExcel = New ADODB.Recordset

With rsExcel
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockBatchOptimistic
End With

sconn = "DRIVER=Microsoft Excel Driver (*.xls);" & "DBQ=" & sFile & "; ReadOnly=False;"
rsExcel.Open strQuery, sconn

Set rsExcel.ActiveConnection = Nothing
Set pblfnOpenExcelRecordset = rsExcel

Exit Function
ErrorHandler:
Debug.Print Err.Description + " " + _
Err.Source, vbCritical, "Import"
Err.Clear
End Function

code

[bilalbajwa2336]

http://docs.google.com/View?docid=dctgg53g_22hpd27q

I basically want this thing to pop up as visual basic program which may connect with Excel.