Exporting recordset to Excel from VB App

[netcashin]

I have a recordset that I want to export out to an Excel spreadsheet from VB app. Any help???

 

[sodakotahusker]

You can open your excel workbook like a database using the ODBC driver and populate a worksheet with your recordset. Or you can open up the excel application using the object model and populate the cells (I always use the macro recorder to capture what I want to do and then duplicate that in my code).

 

[netcashin]

sodakotahusker -- thanks

Will this work when I am creating a new excel spreadsheet on the fly? I am needing to use an excel spreedsheet as a reporting mechanism. And the spreadsheet would be new each time.