>I just created an app that copies a recordset into an excel worksheet. The problem is, when I run the app in some users' pc, i encounter an error about an activex component not being created. I suspect this is due to the different versions of Excel on my pc and user's pc. Is there a way for me to check for different versions of Excel in VB and how to create the excel objects in keeping with the user's version of excel? Some sample code would be a great help. Thanks!
How do you declare your Excel worksheet?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com