Microsoft Office Excel is waiting for another application to complete an OLE action
in [Programming]
|
From: Jim Rech on 8 Mar 2005 09:33 I don't know of a solution for this. It seems that Excel is locked up, not redrawing, etc. until control returns to it. -- Jim Rech Excel MVP "Mircea Pleteriu" <mpleteriu(a)ecom-webfactory.de> wrote in message news:%23rifaa%23IFHA.3528(a)tk2msftngp13.phx.gbl... | 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 | > > > | | > > > | | > > > | > > > | > > | > > | > | > | |
From: Mircea Pleteriu on 8 Mar 2005 09:51 Thanks Jim. "Jim Rech" <jrrech(a)hotmail.com> wrote in message news:OjANIv#IFHA.1248(a)TK2MSFTNGP10.phx.gbl... > I don't know of a solution for this. It seems that Excel is locked up, not > redrawing, etc. until control returns to it. > > -- > Jim Rech > Excel MVP > "Mircea Pleteriu" <mpleteriu(a)ecom-webfactory.de> wrote in message > news:%23rifaa%23IFHA.3528(a)tk2msftngp13.phx.gbl... > | 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 > | > > > | > | > > > | > | > > > > | > > > > | > > > | > > > | > > | > > | > | > >
From: bogdang on 11 Mar 2005 14:53 Mircea, is that dialog box modal? Can you make it always-on-top instead?
First
|
Prev
|
Pages: 1 2 Prev: VBA Error: Method OpenTextFile of IFilesystem3 failed Next: CAN ANYONE SOVLE THIS PROBLEM!!! |