Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Different versions of excel
Message
 
To
06/03/2001 19:04:54
General information
Forum:
Visual Basic
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00481240
Message ID:
00482526
Views:
11
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform