Exporting bunch of data to Excel

[Mauricio Silva]

Hi guys,

I was wondering. Is there a way to export a bunch of data to Excel at once.
I mean, since I create my reports with specific format and formulas, I don't
just use the TransferSpreadsheet, I am exporting data cell by cell,
formating, verifying, skiping lines... but this takes a very long time. Is
there a command or something like:
xlsSheet.Range ("A1:A10") = ListOfData ?

Thanks a bunch
Mauricio Silva

 

[Klatuu]

I think the CopyRecordSetFrom method of the Range object will do what you want.