Save Data into Excel

[susisri]

Hi,
if any one please clear my doubt.
i created one form in vb.it contains(empid,othertsk,descrption....etc)
if any user fill these details click ok then these details are saved into the Excel file.
can anyone tell how to write the code for above form?

[Dököll]

Hi,
if any one please clear my doubt.
i created one form in vb.it contains(empid,othertsk,descrption....etc)
if any user fill these details click ok then these details are saved into the Excel file.
can anyone tell how to write the code for above form?

Hey there, susisri!

Here is a very simple connection to Excel, you'll need to do some leg work to do what you need though:

 
'Declare variables here and be sure to add a reference
Go to Project/References and Check Microsoft Excel 9.0 Object library.
Dim xl As New Excel.Application
Dim xlsheet As Excel.Worksheet
Dim xlWBook As Excel.Workbook
'Don't forget to Quit or you'll have restart your machine/program.
Private Sub Load2Excel_Click() 'Your button
    xlsheet.Cells(1, 1) = Text1.Text
    xlsheet.Cells(1, 2) = Text2.Text
   xlWBook.Save
    xl.ActiveWorkbook.Close False, "C:\Excel_Me.xls"
    xl.Quit
End Sub
 
Private Sub Form_Load()
    Set xlWBook = xl.Workbooks.Open("C:\Excel_Me.xls")
    Set xlsheet = xlWBook.Sheets.Item(1)
End Sub
 
Private Sub Form_Unload(Cancel As Integer)
    Set xlWBook = Nothing
    Set xl = Nothing
End Sub
 
 

Good luck and welcome!

[wassup]

Hi,
if any one please clear my doubt.
i created one form in vb.it contains(empid,othertsk,descrption....etc)
if any user fill these details click ok then these details are saved into the Excel file.
can anyone tell how to write the code for above form?

Hi susisri,
you can try to read this thread.
http://www.thescripts.com/forum/thread645157.html
it may help you a lot.