Add sheet to text file

[RDevos]

That doesn't sound like the right order of business, to me. Since Excel can open a CSV as easily as it opens a spreadsheet, what's the point of doing anything at all to copy? Are you thinking that could be used to move the lines beyond the limit to a new spreadsheet?

if the recordset has more records than there are rows in a sheet
the copying stops at the end of the sheet
and the recordsets recordpointer is on the next uncopied record
and you can just copy the rest of the recordset to another sheet
and so on--and so on, as implied by the remark on the link (i suppose)

but who knows, maybe excel is smart enough to just use a new sheet (who knows ?)
in any case i think it is worth a try