Hai:
I have save vba output in excel, through this vba code's help
Option Explicit
Dim xl As Excel.Application
Dim strFileName As String
'under project_references_ check Microsoft Excel Objects.
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
i want to retrieve stored record to vba output from excel how is it ?
[email protected],
- 24 views