Microsoft Office Excel is waiting for another application to complete an OLE action
in [Programming]
|
From: Mircea Pleteriu on 8 Mar 2005 07:29 Hi, I'm developing a class which for a given filepath has to open the MS Excel and extend the context menu with a new item. When the item is clicked all it has to do is to display a message box. Everything works fine. But if the message box is not confirmed (closed by the user) in a few seconds the "Microsoft Office Excel is waiting for another application to complete an OLE action" is fired by Excel. I want the customer to take his time to read the text and confirm (or not) the message box. How to handle this? Many thanks, Mircea
From: Jim Rech on 8 Mar 2005 07:57 Adding Application.DisplayAlerts = False before invoking the other instance may help. -- Jim Rech Excel MVP "Mircea Pleteriu" <mpleteriu(a)ecom-webfactory.de> wrote in message news:eMmHIn9IFHA.1476(a)TK2MSFTNGP09.phx.gbl... | Hi, | | I'm developing a class which for a given filepath has to open the MS Excel | and extend the context menu with a new item. When the item is clicked all it | has to do is to display a message box. | Everything works fine. But if the message box is not confirmed (closed by | the user) in a few seconds the "Microsoft Office Excel is waiting for | another application to complete an OLE action" is fired by Excel. | | I want the customer to take his time to read the text and confirm (or not) | the message box. | | How to handle this? | | Many thanks, | Mircea | |
From: Mircea Pleteriu on 8 Mar 2005 08:28 Thanks. It works. Second problem. While the message box is displayed, it looks like that the surface of Excel is stuck. That is, if I move the message box window the surface of Excel gets dirty. Any idea how to solve this? "Jim Rech" <jrrech(a)hotmail.com> wrote in message news:unRkl59IFHA.2356(a)TK2MSFTNGP14.phx.gbl... > Adding Application.DisplayAlerts = False before invoking the other instance > may help. > > -- > Jim Rech > Excel MVP > "Mircea Pleteriu" <mpleteriu(a)ecom-webfactory.de> wrote in message > news:eMmHIn9IFHA.1476(a)TK2MSFTNGP09.phx.gbl... > | Hi, > | > | I'm developing a class which for a given filepath has to open the MS Excel > | and extend the context menu with a new item. When the item is clicked all > it > | has to do is to display a message box. > | Everything works fine. But if the message box is not confirmed (closed by > | the user) in a few seconds the "Microsoft Office Excel is waiting for > | another application to complete an OLE action" is fired by Excel. > | > | I want the customer to take his time to read the text and confirm (or not) > | the message box. > | > | How to handle this? > | > | Many thanks, > | Mircea > | > | > >
From: Bob Phillips on 8 Mar 2005 08:35 Have you got screenupdating turned off? -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" <mpleteriu(a)ecom-webfactory.de> wrote in message news:OHMPBI%23IFHA.3336(a)TK2MSFTNGP10.phx.gbl... > Thanks. It works. > Second problem. While the message box is displayed, it looks like that the > surface of Excel is stuck. That is, if I move the message box window the > surface of Excel gets dirty. > > Any idea how to solve this? > > "Jim Rech" <jrrech(a)hotmail.com> wrote in message > news:unRkl59IFHA.2356(a)TK2MSFTNGP14.phx.gbl... > > Adding Application.DisplayAlerts = False before invoking the other > instance > > may help. > > > > -- > > Jim Rech > > Excel MVP > > "Mircea Pleteriu" <mpleteriu(a)ecom-webfactory.de> wrote in message > > news:eMmHIn9IFHA.1476(a)TK2MSFTNGP09.phx.gbl... > > | Hi, > > | > > | I'm developing a class which for a given filepath has to open the MS > Excel > > | and extend the context menu with a new item. When the item is clicked > all > > it > > | has to do is to display a message box. > > | Everything works fine. But if the message box is not confirmed (closed > by > > | the user) in a few seconds the "Microsoft Office Excel is waiting for > > | another application to complete an OLE action" is fired by Excel. > > | > > | I want the customer to take his time to read the text and confirm (or > not) > > | the message box. > > | > > | How to handle this? > > | > > | Many thanks, > > | Mircea > > | > > | > > > > > >
From: Mircea Pleteriu on 8 Mar 2005 08:58 It's turned on (as default). "Bob Phillips" <bob.phillips(a)notheretiscali.co.uk> wrote in message news:OuAkFP#IFHA.2728(a)TK2MSFTNGP09.phx.gbl... > Have you got screenupdating turned off? > > -- > > HTH > > RP > (remove nothere from the email address if mailing direct) > > > "Mircea Pleteriu" <mpleteriu(a)ecom-webfactory.de> wrote in message > news:OHMPBI%23IFHA.3336(a)TK2MSFTNGP10.phx.gbl... > > Thanks. It works. > > Second problem. While the message box is displayed, it looks like that the > > surface of Excel is stuck. That is, if I move the message box window the > > surface of Excel gets dirty. > > > > Any idea how to solve this? > > > > "Jim Rech" <jrrech(a)hotmail.com> wrote in message > > news:unRkl59IFHA.2356(a)TK2MSFTNGP14.phx.gbl... > > > Adding Application.DisplayAlerts = False before invoking the other > > instance > > > may help. > > > > > > -- > > > Jim Rech > > > Excel MVP > > > "Mircea Pleteriu" <mpleteriu(a)ecom-webfactory.de> wrote in message > > > news:eMmHIn9IFHA.1476(a)TK2MSFTNGP09.phx.gbl... > > > | Hi, > > > | > > > | I'm developing a class which for a given filepath has to open the MS > > Excel > > > | and extend the context menu with a new item. When the item is clicked > > all > > > it > > > | has to do is to display a message box. > > > | Everything works fine. But if the message box is not confirmed (closed > > by > > > | the user) in a few seconds the "Microsoft Office Excel is waiting for > > > | another application to complete an OLE action" is fired by Excel. > > > | > > > | I want the customer to take his time to read the text and confirm (or > > not) > > > | the message box. > > > | > > > | How to handle this? > > > | > > > | Many thanks, > > > | Mircea > > > | > > > | > > > > > > > > > > > >
|
Next
|
Last
Pages: 1 2 Prev: VBA Error: Method OpenTextFile of IFilesystem3 failed Next: CAN ANYONE SOVLE THIS PROBLEM!!! |