vb6 to excel

01-09-2004, 02:21 AM
hello guys..

i m developing an access database application using vb6...in this application i have a search engine...now i want to display the search results in the ms excel sheet....can anyone pls tell me how to do his...


01-09-2004, 02:29 AM
Take the records into the recordset object and pass it to excel by an excel object. For this declare a reference object for the excel and pass records cell by cell

For excel, VB6 operation U can find the plenty of code samples from VBA section of this forum. I also posted one or two samples for the same task

01-09-2004, 02:29 AM
You can open up an Excel Object and begin writing to an Excel Worksheet. There are plenty of examples of this on the forum, Just go through some of these results (http://www.visualbasicforum.com/search.php?searchid=559636)

01-09-2004, 02:35 AM
thanx guys...i m having look on the result and hope that will help

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum