>Eric,
>
>Thanks for the reply. Do you know where I could get some example code that does this?
You can try:
With mobjXL
.Worksheets(1).Activate
.Range("A3").Resize(lngNBRow, lngNBCol) = arrRecordset
End With
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com