DataGrid to Excel

[New_Coder]

Is there an easy way to get the infomtion from a DataGrid and dump it into MS Excel using VB6?

[Sam Xavier]

Here is a nice article on MSDN which discusses this: http://forums.msdn.microsoft.com/en-US/vbide/thread/5671b863-9c37-4923-8938-090053289712[^]

Best Regards, Sam Xavier www.componentone.com

[Lost User]

You can export the data from Datagrid to MSEXCEL. How can it possible pls contact ? Cheers Anubhava Dimri anubhava.prodata@gmail.com :doh: 9250168195 :doh:

[New_Coder]

I am using VB6 - the datagrid I want to export to Excel is about 5000 records 20 colums wide. Is there a way to dump the entire datagrid at once or does one need to read each record/cell and transfer it to Excel?