Information générale
Catégorie:
COM/DCOM et OLE Automation
>>PMFJI, the Excel property DisplayAlerts is very similar to SET SAFETY. If you set it to .f., Excel doesn't display alert messages:
>>
>>oExcel.Application.DisplayAlerts = .f.
>
>Thanks for the reminder. I tend to forget that one. However, I know that Della had some reason for doing things the more complex way in the way. Maybe she'll see her name and chime in here.
The reason why I don't always think of oExcel.Application.DisplayAlerts is that it *used* to only work inside of macros, meaning that you had to actually be running a macro inside of Excel. It reset itself after the end of the macro, or in Automation cases, it always set itself back to .T. at the end of the call. I'm not sure when it got fixed...I ran into the problem in Excel '95, and it was fixed in either 97 or 2000. Since I can't remember, I'll just be safe and say that '97 *might not* work as you think it should, so be prepared for the workaround. <s>
- della
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement