Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Quite Excel No save
Message
 
À
30/12/2005 13:13:35
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01082087
Message ID:
01082089
Vues:
9
....
oExcel.DisplayAlerts = .f.
....
As in Excel VBA Help for Quit Method
Quits Microsoft Excel.

expression.Quit

expression Required. An expression that returns an Application object.

Remarks
If unsaved workbooks are open when you use this method, Microsoft Excel displays a dialog box asking whether you want to save the changes. You can prevent this by saving all workbooks before using the Quit method or by setting the DisplayAlerts property to False. When this property is False, Microsoft Excel doesn’t display the dialog box when you quit with unsaved workbooks; it quits without saving them.

If you set the Saved property for a workbook to True without saving the workbook to the disk, Microsoft Excel will quit without asking you to save the workbook.



>Hi All
>
>Is there a way to quite excel using automation without getting save/cancel dialog box?
>
>Thanks.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform