>Actually, the problem occurs here:
>
>>> Set xlApp = CreateObject("Excel.Application")
>
>Excel97 doesn't fire up, but Excel 2000 does. What do you think's wrong?
Try this:
-Remove the reference to Excel.
-Declare as object (Dim xlApp as Object).
-Instantiate your object (Set xlApp = CreateObject("Excel.Application"))
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com