Need a help to export data in Form to excel sheet to save them in that..

[hegde123]

Dear experts! I need a help. I had made a small Bill format and i need it to be exported and save it in an excel sheet. Please help me anybody. I will put here my codes....

Option Explicit

Private Sub Command1_Click()
Text11.Text = Val(T1) * Val(T7)
Text12.Text = Val(T2) * Val(T8)
Text13.Text = Val(T3) * Val(T9)
Text14.Text = Val(T4) * Val(T9)
Text15.Text = Val(T5) * Val(T10)
Text16.Text = Val(T6) * Val(T11)
Text5.Text = Val(Text11.Text) + Val(Text12.Text) + Val(Text13.Text) + Val(Text14.Text) + Val(Text15.Text) + Val(Text16.Text)
End Sub

Private Sub Form_Load()

    'center the form:
    Me.Top = (Screen.Height - Me.Height) / 2
    Me.Left = (Screen.Width - Me.Width) / 2

    'display date & time
    lblDate.Caption = Format$(Date, "m/d/yyyy")
    lblTime.Caption = Format$(Time, "h:nn AM/PM")

End Sub

Private Sub cmdPrint_Click()

    cmdPrint.Visible = False
    cmdExit.Visible = False
    
    PrintForm
    
    cmdPrint.Visible = True
    cmdExit.Visible = True
    
End Sub

Private Sub cmdExit_Click()
    End
End Sub

Please Guys Help me to save the data from my text boxes in either excel or as text file

[twinnyfo]

hedge123,

Unfortunately, you don't give us much to go on. We don't know where you want to save your data (other than "to excel") and it appears you have yet to try to implement anything to perform this function (using the vast number of tools available on this site--and others).

We will not build your project for you, especially when we don't know what your result is supposed to look like.