Free Microsoft Excel 2013 Quick Reference

Microsoft Excel is waiting for an OLE action to complete

This message occurs occasionally when I am controlling Word from Excel. But when it occurs I have to use Task Manager to shutdown Excel. I think I know why it happens. It probably happens when the user closes the Word document during the While Wend line:


	VB:
	
 wordapp = GetObject(, "Word.Application") 
 
While wordapp.Application.BackgroundPrintingStatus  0 
Wend 
 
wordapp.ActiveDocument.Close savechanges:=False 
If wordapp.Documents.Count = 0 Then wordapp.Quit False 
Set wordapp = Nothing 
 
AppActivate "Microsoft Excel" 
 
End If 
 
Exit Sub 
 
printbox_err: 
 
If Err.Number = 462 Then 'remote server does not exist - word closed
     'Resume Next
    Set wordapp = Nothing 
    Application.EnableEvents = True 
    End 
End If 
 
If Err.Number = 429 Then 'can't create object as word closed
    Set wordapp = Nothing 
    Application.EnableEvents = True 
    End 
End If 
 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Most of the time if the user shuts Word during background printing then the While Wend line generates error 462 and it closes OK. But sometimes I get this OLE waiting message. I read online that it may be because Word is partially still in memory. Is there anything I can do? Turning off DisplayAlerts will just mean Excel freezes with no warnings I would say.


Post your answer or comment

comments powered by Disqus
Hello all

I have this report in Excel 2003 that is pulling all the data through
an ODBC connection. Right now I am trying to change the ODBC data
source, I am doing this by opening the MS Script Editor and changing
it there. My problem is when I try to open the script editor I keep
getting this message "MICROSOFT EXCEL IS WAITING FOR AN OLE ACTION" it
is driving me crazy, I am about to break the computer, seriously. I
say OK, to this message and after few seconds it pops again and again
and again. I have to click multiple times until finally my script
editor opens.

My question: How do I solve this problem? is there an option I need to
uncheck or something?

Thanks in advance...

Excel 9

H

I'm using the CreateObject Command in Excel to launch Word and execute a mailmerge. I keep getting the following error msg if there are more than 100 records to merge

"Microsoft Excel is waiting for another application to complete an OLE action

From what I understand, this message appears when I try to run code in excel before the server has finished executing code in Word. I've checked the code but I don't execute code in Excel before closing Word. Is there anyway that I can suppress this message? Also, why is it only happening when there are more than 100 records? Is it purely a server issue?

We have spreadsheets on our intranet Sharepoint Team Sites. If a user opens
one of those spreadsheets from the intranet with Internet Explorer, closes
the browser window, then tries to save the spreadsheet from Excel, there is
a pause, then the message "Microsoft Excel is waiting for another
application to complete an OLE action." Clicking OK just causes another
pause and the same message appears over and over until Excel is terminated
from the task list. The key here seems to be closing the browser window
while the spreadsheet is open in Excel.

Any idea how to fix this?

Thanks!
Glen

While debugging an ActiveX dll Visual Basic by the Visual Basic IDE, after a
short period, Excel reports ' Microsoft Excel is waiting for another
application to complete an OLE action', after clicking OK, Excel looses the
reference to the dll and I have to start the debugging again.

How can I configure this message not to appear ?

We have spreadsheets on our intranet Sharepoint Team Sites. If a user opens
one of those spreadsheets from the intranet with Internet Explorer, closes
the browser window, then tries to save the spreadsheet from Excel, there is
a pause, then the message "Microsoft Excel is waiting for another
application to complete an OLE action." Clicking OK just causes another
pause and the same message appears over and over until Excel is terminated
from the task list. The key here seems to be closing the browser window
while the spreadsheet is open in Excel.

Any idea how to fix this?

Thanks!
Glen

Hi,
I am trying to open an excel sheet by using VBA in
Excel. But, this particular sheet is maintained by other
person and is password protected. My code works perfect
when the file is opened by the other person
in the editing mode but fails to open the file when its
closed or not in the editing mode. I am not able to trace
the reason. I am left with this error message when the
file is closed by the other person.

"Microsoft excel is waiting for other program to finish
OLE action"

Code:
Dim xls as New Excel.Application

xls.workbooks.open("G:sample.xls")

Excel fails when I try to open this location ... why does
it do so ??????????/

I have a program that automatically create reports through SQL and Excel. It
opens report templates, runs the associated SQL, creates and exports the
reports to defined directories. I need to run an Access application to
generate one particular set of reports. It works, but after so many minutes I
get this "Microsoft Office Excel is waiting for another application to
complete an OLE action."

I don't mind the message as Access will complete its tasks and come back to
the scheduler. However, the message box is still up there and I have to click
it to go to the next report. Is there a way I can program around or through
the message box?
Candyman

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

I have excel 2002. I inserted hyperlinks via a vba .bas file that I created using a shell script. I imported the bas file by clicking tools>> macro>> vba editor >> import. A module was created. I then clicked "run" and closed the vba editor. Everything looked ok. The links were inserted properly. But, when I click on a link it does not open follow the link. The hour-glass appears. Nothing happens (it should open a pdf file. After five or ten minutes, I try to close excel but I get this message: "Excel is waiting for another ole object to complete an OLE action." What do I need to do to automate the creation of hyperlinks / import macros? Here's a snippet of my vba code.

Sub
Macro1()
'
' Macro1 Macro
'

'
Range("B1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="source/0001.pdf"
Range("B2").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="source/0002.pdf"
Range("B3").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="source/0003.pdf"
End Sub


the connection to microsoft exchange is unavailable. outlook must be online to complete this action error in Vista

I recently re installed OUtlook 2007 and a tech from my ISP clicked this by mistake while he was on line with me.  He then told me to use Microsoft Mail program instead .  I think he realized he screwed up and got me off Outlook 2007.  The problem wiht this is I can't download my .pst files.  I want to go back to Outlook 2007 but it won't let me erase the Microsoft Exchange Server setting window.  How do I erase this and start new?

HI

I have a workbook which has a macro which exports data from a user to myself by attaching a file to an email. However the user has received an error "Microsoft Office excel is waiting for another aplication to complete an OLE action." What is an OLE action.

Could anybody suggest an answer? Many Thanks

Hi:
Pls can someone help me with this issue.

About a month ago, I had tried to check out an Excel from a document
management system that my company uses. There was an option to "check
out and open doc". So I selected that. Unfortunately, during the
sequence, the procedure hung. So, I bailed out by doing a
Ctrl-Alt-Delete and killing procedure. After that, whenever I try
opening Excel to a blank spreadsheet or an existing Excel file, I get
these error messages:

Microsoft Excel is waiting for another application to complete an OLE
action.

ActiveX Component Can't Create Object

I get the "ActiveX Component Can't Create Object" for all MS Office
files in their native application (Word, PPT).

I have tried reinstalling the Office suite but the problem persists.
Can someone please help me with this? What should I do?

Thanks!!!

I have been using MSN stock quotes for sometime without a problem
retrieving data. Now I get the following messages "MO Excel is waiting
for another application to complete an OLE action" this notice repeats
3 times and then the following message appears "There was a problem
displaying the attributions. The quotes have not been updated" Thank
you for your help.

Frank

Hi:
Pls can someone help me with this issue.

About a month ago, I had tried to check out an Excel from a document
management system that my company uses. There was an option to "check
out and open doc". So I selected that. Unfortunately, during the
sequence, the procedure hung. So, I bailed out by doing a
Ctrl-Alt-Delete and killing procedure. After that, whenever I try
opening Excel to a blank spreadsheet or an existing Excel file, I get
these error messages:

Microsoft Excel is waiting for another application to complete an OLE
action.

ActiveX Component Can't Create Object

I get the "ActiveX Component Can't Create Object" for all MS Office
files in their native application (Word, PPT).

I have tried reinstalling the Office suite but the problem persists.
Can someone please help me with this? What should I do?

Thanks!!!

i have a macro that opens a webpage, 99.9% of the time it works, for some
reason this time the webpage did not open and i got a message that
says...Microsoft Excel is waiting for another application to complete an OLE
action.
is there any way to get around this or at least be able to save excel before
i close it?

thanks in advance

When clicking a hyperlink in Excel I got a message stating Excel was waiting
for an outside OLE action. The only option Excel gave me was to click OK or
close the message. After clicking OK several times I gave up hope that Excel
would give me another option or resolve the issue. I couldn't even save my
work. I had to open the Task Manager and end the program Excel.

I recommend adding an option to cancel the outside OLE action request.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

When clicking a hyperlink in Excel I got a message stating Excel was waiting
for an outside OLE action. The only option Excel gave me was to click OK or
close the message. After clicking OK several times I gave up hope that Excel
would give me another option or resolve the issue. I couldn't even save my
work. I had to open the Task Manager and end the program Excel.

I recommend adding an option to cancel the outside OLE action request.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Hello,

When debugging my dll used from XL, I systematically get this message with a flashing in the taskbar:

Microsoft Office Excel is waiting for another application to complete an OLE action. A few seconds are enough to get this message which is rather perturbing when I am concentrated on debugging something.

Would you know how to get rid of that message?

Hi!
I experience recurring problem with hanging MS Excel application indicating that it is waiting for another application to complete an OLE action.
"Microsoft Office Excel is waiting for another application to complete an OLE action"
I determine that it occurs in situation when trying to open a hyperlink from excel in IE Web Browser.
This hyperlink leads to a web application on a remote machine and after it occur every hyperlink from excel
on that machine leading to this web application ends up with this error. Such state lasts for a couple of
hours in which Excel application hangs and cannot be closed other that with task manager (apparently after some time application does complete an OLE action because links from excel can be activated again, until
another OLE Action shows up).

The most frustrating thing is that this error doesn’t occur always in such circumstances.
The server on which the problem can be found is a Windows 2003 Terminal Server which support about 20 users
at the time with many of them summoning very similar addresses from their excels. My guess is that it may
have to do something with simultaneously executing queries about pages in web browsers from excel in a remote
connection.
If you have any slightest ideas of how can I get rid of such problems I would be delighted to hear them.
Thank You in advance.

H.

I use a macro in Excel 2000 to filter the worksheet, copy the filtered
range, and then call a Word document. The Word document has AutoOpen and
other macros to paste in the cells and format them as a Word table. That
all works well.

But when the Word doc closes, I'm looking at an error message in Excel:
"Excel is waiting for another application to complete an OLE action." As
soon as I click OK, the error box closes and the macro finishes.

As soon as the Excel macro calls Word, I'd like to just reset the worksheet
and be done with Excel. Is there a way I can do this? The code after
calling Word is below. Thanks for any help given.

Ed

Set WD = CreateObject("Word.Application")
WD.Documents.Add ("ERT_EFF_List(num)")
' Reset worksheet
' Unhide everything
Sheets("Sheet1").Activate
Sheets("Sheet1").AutoFilterMode = False
With Cells
.EntireColumn.Hidden = False
.EntireRow.Hidden = False
End With
Application.CutCopyMode = False
Range("A1").Select
Application.ScreenUpdating = True

I have a Excel Macro:

Sub MailMergeFromExcel
...
Set W_app = CreateObject("Word.Application")
Set W_doc2 = W_app.Documents.Add
With W_app
Source = "D:DOCSEXCELdata.xls"
W_doc2.Activate
W_doc2.Select
.ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
.ActiveDocument.MailMerge.OpenDataSource Name:=Source _
, ConfirmConversions:=False, ReadOnly:=True, LinkToSource:=False, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:="DATOS_CONTRIB", _
SQLStatement:="", SQLStatement1:=""
....
End With
...
End sub

The problem of Excel Macro is in the sentence "...OpenDataSource..." it's very slow, and sometimes show me a Message: "Microsoft Excel is waiting for another application complete an action OLE" (but before Excel try to open PERSONAL.XLS and I click "Read Only").

I try with this code:

W_doc2.MailMerge.OpenDataSource Name:=Source _
, ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _ AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _ Format:=wdOpenFormatAuto, Connection:= _
"Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=Source;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet" _
, SQLStatement:="SELECT * FROM [Sheet1$]", SQLStatement1:=""

But didn't work

Please, help me.

Hi,

I have an Excel spreadsheet with macros in it. The VBA code connects to a JMS queue over Weblogic and sends an XML message. This was working all fine till I was using Office 2003.

I moved to office 2007 around 2 weeks back and now even if I open the VBA editor(ALT + F11) and then try to run the macro again, then the excel freezes and after 3-4 minutes, I get the message box as "Microsoft Excel is waiting for another application to complete an OLE action".

If I don't open the VBA editor and just open the excel and use it, then it works fine so obviously it is having issues when saving again some of the code in VBA. On further analysis, I found that the excel is freezing at the following statement :

Please advise.
Let me know if any other details are needed.

NOTE: I don't get any errors on compiling it.

Can anyone please help in trying to resolve this issue? We are trying to copy and paste values from one worksheet in 2007 to an new worksheet in 2007, which resides in a new workbook under a new Excel window. The "Paste Values" option is not available under the Paste Options button. However, when you click on Paste, we an error stating: Microsoft Excel is waiting for another application to complete an OLE action.

Also, if you were to click on Paste Special, the usual choices are not present, however options to paste as a Picuture, Bitmap, etc...are only available.

We also just upgraded from 2003 to 2007, and all of the worksheets/books we use were developed in 2003, and contain many functions, macros, and forumulas.

Any thoughts? Thanks!

I am running a macro using VB and OLE to run a
a very CPU intensive program and I keep geetting
an annoying MsgBox with an OK button that says,
"Microsoft Excel is waiting for another application
to complete an OLE action. " every 30 seconds.
Is there any way to turn this off ???
please help RS


No luck finding an answer? You could always try Google.