Hai:
I have developed this code for store vba output in excel. and i dont know the correct source code for retrive (bring again) that record from excel pls send source code for this. [email protected]
code:
Private Sub CommandButton1_Click()
TextBox3.text = Val(TextBox1.text) + Val(TextBox2.text)
Set xl = CreateObject("excel.Application")
xl.Workbooks.Open ("C:\Documents and Settings\OTHERS\My Documents\testbed\270810_new vb.xls") ' substitute your file here
xl.Visible = False
xl.Worksheets("Sheet1").Range("B1").Value = TextBox1.text
xl.Worksheets("Sheet1").Range("C1").Value = TextBox2.text
xl.Worksheets("Sheet1").Range("D1").Value = TextBox3.text
xl.Worksheets("Sheet1").Range("A1").Value = TextBox4.text
ActiveWorkbook.Save
xl.Application.Quit
Set xl = Nothing
End Sub
- 1 view