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:

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