Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automating Excel
Message
General information
Forum:
Visual Basic
Category:
COM, DCOM and OLE automation
Miscellaneous
Thread ID:
00516687
Message ID:
00517026
Views:
28
>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform