by Gil Shabthai (7 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: (3 Votes)
I did not write this code by myself , i had found it at https://support.microsoft.com/support/kb/articles/Q246/3/35.ASP
With this code you can transfer the contents of an ADO recordset to a Microsoft Excel worksheet by
automating Excel , this code will work only with Excel 2000 or 2002 , for Execl 97 use my previous examples, or just look at this examlpe for basic knowledge at the IF statement.