Hi

What i m trying to do is quite simple.
I have retrieved data from my SQL database and displayed it in my VB application through a list view control. Now I want that at a click of a button this displayed data should get exported to an excel file (created on the fly)

But the problem is that I m unable to create an object of excel in my VB application. I have referenced the "Excel Object Library" and m trying to create an object the following way:

Set oXL = OLEExcel.object.Application
But the object does not get created :(

Any help

Hi Neha,

You can do the following:

Refer to Microsoft Excel 9.0 Object Library.

Use the following Code:

Dim ExcelApp As Excel.Application
Dim ExcelWSheet As Excel.Worksheet

Set ExcelApp = CreateObject("excel.application")


ExcelApp.Workbooks.Add
Set ExcelWSheet = ExcelApp.ActiveWorkbook.Sheets("Sheet1")

'Assign the values from the database to the excel worksheet
ExcelWSheet.Range("A1") = "Your RecordSet Value"
'And similarly you can populate in the other cells

ExcelApp.ActiveWorkbook.SaveAs "FilePath and FileName"
ExcelApp.ActiveWorkbook.Close
Set ExcelApp = Nothing

Hope this helps,

Thanks,

Lalit
Life Means More...;)