How do I display vb generated data in and EXCEL SPREADSHEET

[kemsu]

I am writing an applications that reads in data from a text file database, and manipulates the data. I want to display the result from the calculations in a Excel Spreadsheet..

Please anybody help

 

[ddc821]

Use Excel Automation to create a spreadsheet with your data
A good reference for you would be:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q247412&

Here's a code example that moves an array into an Excel spreadsheet:
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object

Set oExcel = CreateObject("Excel.Application&quot
Set oBook = oExcel.Workbooks.Add

'Add headers to the worksheet on row 1
Set oSheet = oBook.worksheets(1)

oSheet.Range("A1&quot.Value = Array("Product ; Account Number&quot
oSheet.Range("A1&quot.Font.Bold = True
oSheet.Range("A1&quot.EntireColumn.AutoFit

'Transfer the array to the worksheet starting at cell A2
oSheet.Range("A2&quot.Resize(lCtr + 1).Value = dataArray

'Save the Workbook and Show it
strFileName = "c:\spreadsheet.xls"

If Dir(strFileName) <> &quot;&quot; Then Kill strFileName

oBook.SaveAs strFileName

Call ShellExecute(Me.hwnd, &quot;open&quot;, strFileName, &quot;&quot;, 0, 1)