[RBForums] General: Export RecordSet or ListBox to Excel

[rbforumnotifier]

New topic in General: 

Export RecordSet or ListBox to Excel

danielmullins - Mon Jun 09, 2008 10:05 am

<http://forums.realsoftware.com/viewtopic.php?t=22818>
                                                                                
                                                                                
Hi,

I hope someone has some code in their library.

I want to export either a recordset or a listbox to Excel via OLE

I can do this, when i know what rows are in the output, problem is when im 
using multiple querys and one function.

So if anyone has some code laying around, it would be handy.  I found a 
example, but it only worked with up to 52 colums, some of my data is in the 
20,000 mark (Still less than excels worksheet limit of 64,000 something).

Thanks

Daniel                                  
                                                                                
                                                                                
                                                                                
                                                                                
                                        




-- 
Over 900 classes with 18000 functions in one REALbasic plug-in. 
The Monkeybread Software Realbasic Plugin v8.1. 

&lt;http://www.monkeybreadsoftware.de/realbasic/plugins.shtml&gt;

rbforumnotifier@monkeybreadsoftware.de