Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel oddity
Message
 
To
24/03/2004 11:21:19
Gary Foster
Pointsource Consulting LLC
Chanhassen, Minnesota, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00889289
Message ID:
00889311
Views:
19
If you have one Excel visible, but there are two Excels in the task manager, then you probably did not close one of them properly from your program (perhaps leaving some excel objects or related variables not released).

>I have a VFP8sp1 app on my users Win2k machines that uses GetObject() to grab some highlighted cells from an open Excel spreadsheet to do some work with. Sometimes my program chokes and claims Excel isn't open, even though it clearly is. If I look in the task manager I see two instances of Excel open. If I shut down the visible instance, one still remains. This confuses GetObject() something terrible.
>
>Has anyone else ever run into this? More to the point, does anyone have a suggestion on how to get Excel to pick the "right" instance? Thanks.
>
>Gary
Previous
Reply
Map
View

Click here to load this message in the networking platform