Hi

Has anybody got some good examples for writing data to excel from a VB6 app?
I need to create a new workbook, name and create about 10+ sheets. Then write data to the sheets and save it and close it all in the background.
Would it be better to use ODBC(excel driver) to write the data and handle the sheets as tables? In previous apps I used DTS in SQLserver but this time it will not work for me.

Please point me in the right direction.

Hello,

I don't know what your best option is; you can use ODBC, however if you need custom formatting other than a standard CSV format, using the excel objects is fine.

Found something on the web that may help: http://www.it-faq.pl/data/misc1/EN-US/219/151.htm

Brian

Thanks! Thats perfect. Will play around with it but it seems this method will support any Excel VBA.

hai i understand ur prob
add excel9.olb library to ur vb library set
then using help for their methods and classes
u can easily got ur result.........
because recently i also developed
a system with same requirement.........bye..