>>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.