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 :(