Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Close excel workbook
Message
De
04/11/2011 11:50:23
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
01528071
Message ID:
01528084
Vues:
31
>>Hi all -
>>When issuing a COM command to close an excel workbook (oBook.Close) excel now wants to confirm the close which seems to be a new feature MS has added. Does anyone know of a way to avoid the confirm message so the program will just keep going ?
>>Thanks
>
>Hi Don,
>
>In vba excel the instruction would be oBook.Close False, where the False stands for SaveChanges.
>
>I guess in vfp you would oBook.Close(.f.).
>
>You might want to save before you close.
>
>You might also try application.displayalerts = false, where application translates in to your Excel object in VFP.
>
>Good luck,
>
>Marc

Thanks Marc.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform