Basic scripts run fine for excel, but are slow when dealing with large data files (1000+ lines).
Here are two sites that have helped me:
http://www.4guysfromrolla.com/webtech/010401-1.shtml
http://www.avdf.com/apr98/art_ot003.html
http://stackoverflow.com/questions/536636/write-array-to-excel-range

I found this to GREATLY improve performance when searching, less so in writing.  Any other tips out there?

CopyFromRecordset ? [edit: YES!!]
 – but first, get the array to a recordset
    (define recordset)

interesting..  recordset to XML

also, this is a complete listing of syntax for the RANGE method

Advertisements