>Good Evening,
>
> Any code to export a filtered recordset to an excel file?
>
> Million Thanks.
If your recordset is DAO, you can use the CopyFromRecordset method (of the Range object).
If ADO, you can copy your recordset into a array (using the GetRows method of the recordset) and then copy your array.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com