View original (French)

Excel VBA Macros do not display alerts

mikanadien Posted messages 198 Status Member -  
0kid0ki Posted messages 192 Status Member -
Hello everyone,

I have a minor issue but it's bothering me quite a lot.
In an Excel macro, I create an "external application" object (it's not really the class of the object but at least you've understood... lol) so that from Excel, we can launch this external application by clicking on an image...

Everything works perfectly...

The minor issue I have is that since the application takes time to start, after 20-30 seconds, Excel shows me a warning pop-up "Excel is waiting for an external OLE application".

Do you have any idea of how I can stop this alert from appearing?

A display = false or something?

Thank you for your help...

Configuration: Fujitsu Siemens Esprimo Mobile 6535 in the bag

CM Asus KN8-VM + Amd Sempron 1.6 GHz 1Go of RAM at home... And that's more than enough...

2 answers

  1.
    Bidouilleu_R Posted messages 1209 Status Member 296
     


    application.DisplayAlerts=false

    it is imperative to restore it to True as soon as you finish your loop, in fact as soon as possible.

    you then put
    application.DisplayAlerts=true

    Edit
    Otherwise, error messages are suppressed
    4