>>>>I recall someone giving me advice on sending a batch of data to excel in a single call rather than sending each cell explicitly, but I am unable to locate my notes on the subject. Would someone indulge my lack of memory and organization and share that technique with me again?
>>>>
>>>>Thanks
>>>
>>>See if this Re: Best way to re-factor Thread #1135774 Message #1135791 can be of any help. I use Cetin's technique if I have a file with memo fields, otherwise just use copy to (will copy 16K records only) and then apply some formatting.
>>
>>Copy to xl5 and then applying some formatting is a fairly easy and fast way to do it if you want a standard spreadsheet, but if you want something special where the record occupies multiple rows in excel the challenge is a little more difficult. I typically use a scan loop or a for/next like:
>>

>>for i = 1 to reccount()
>>cell = "A" + transform(i)
>>.range(cell).value = field1
>>cell = "B" + i
>>.range(cell).value = field2
>>* etc
>>next
>>

>>
>>but this one cell at a time is slow due to the multiple calls to excel. Same with formatting calls.
>
>What exactly do you want to achieve?

The end game is faster, cleaner, more efficient code. Somewhere I got the idea that the spreadsheet could be set up and sent to excel with a single call. Sort of like =TableUpdate.