>I would like to know how I can save the data in an active recordset to an xls document
>
>Thanking you for your help and interest
You can create a text file with a .CSV extension (which is natively readable form Excel). You can also open Excel from VB, dump data in it and save it.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com