>>>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?
If it's not broken, fix it until it is.
My Blog