Loading

Retrieve vba output from excel

1 post / 0 new
Offline
Joined: 08/06/2010
Retrieve vba output from excel

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 ?
maddyrafi@gmail.com,

Add new comment

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.