Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with VFP and Excel 2000?...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00308023
Message ID:
00308032
Vues:
31
Hi George,

Aaaaaahhhh ... OLE ... :-)

Just tried your example and oExcel.Quit leaves EXCEL.EXE in the Task Manager, BUT oExcel = NULL shut down EXCEL.EXE. Here's the BIG BUT, I'm running NT4.0 SP5, so I would conclude it's a problem in Win98 or some interaction between VFP and Win98.

Bill

>...or Geo's continuing Adventure with OLE Automation"
>
>Hi troops,
>
>Could some try this and see if it's just me or if there's a problem with VFP 6.0 SP3/Excel 2000. This is on Win 98SE.
>oExcel = CREATEOBJECT('Excel.Application')
>oExcel.Quit
Now according to the documentation this should clear all instances of the automation server. However, when I go to the Task Manager, there's Excel plain as day. I've tried oExcel = NULL and RELEASE oExcel in addition to the above. No difference. In fact the only way I've found to purge the existence of Excel from the task manager is to quit VFP entirely. This makes me think that there's an internal problem with VFP releasing the object reference.
>
>The problem is that unless the instance of Excel is released, subsequent creation of any additional Excel servers cause them to be almost, but not quite, completely transparent when displayed.
>
>I'm out of ideas here. I've tried SendMessage() with WM_PAINT to fix the display problem. I've tried WM_CLOSE to shut it down with no luck (Excel GPFs and my entire machine goes into slow motion).
>
>I've searched the KB and can't find a reference to this.
>
>Any clues, suggestions or other information would be appreicated.
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform