Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Automating Excel
Message
Information générale
Forum:
Visual Basic
Catégorie:
COM, DCOM et OLE automation
Divers
Thread ID:
00516687
Message ID:
00517026
Vues:
29
>>My problems:
>>1. When I run the app, Excel flashes briefly and disappears. How do I make it stay visible so that the user can work with it?
>>2. It appears this instance of Excel is kept alive (although not visible) with the newly created file open. Therefore, I can't reopen the file until I "kill" the instance of "Excel" running via Task Manager. Why isn't it killed when I set the object ref to "Nothing"?
>
>1. Because you Quit. You must leave it open and close it only when you exit the application.
>2. Because one object stay instantiate.

1. Duh. I guess this is what happen when you copy code and don't think about what it's actually doing.
2. It looks like instance of Excel is destroyed when the app exit but kept alive even when you close Excel. Interesting.

Now, if only I could get the Crystal Report problem solved, I would feel good about this week's work. Thanks Eric.
It's "my" world. You're just living in it.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform