Excel Ole Error Message
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 15 Oct 2016 09:54:46 GMT by s_wx1131 (squid/3.5.20)
Complete an OLE Action By Dick Kusleika in Automation, VBA on June 25, 2015. Have you ever seen this message? It's not an error. You can't click Debug and go see which line of code ole error 800ac472 excel it's on when this happens. You can't even click Cancel. All you microsoft excel is waiting for another application to complete an ole action loop can do is click OK every 10 seconds or so until it's done. Brutal. I ran into this ole action word message recently on some code that someone else wrote but that I'd modified (see how I'm already deflecting the blame). The code runs through a hundred or so customers and http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/microsoft-excel-is-waiting-for-another-application/a2dcb2a7-8e49-4db5-96de-eb29010f2f67 sends them an email. Each customer has its own worksheet and that worksheet is turned into HTML to be used in the body of the email. Incidentally they used Ron de Bruin's RangeToHTML function to do the conversion. I happened to have written that function back when I had a website called dicks-clicks.com. Ah, memories. The code I modified was working http://dailydoseofexcel.com/archives/2015/06/25/excel-is-waiting-for-another-application-to-complete-an-ole-action/ well for a few weeks before it started acting up. One line in the code looks like this sh.ExportAsFixedFormat xlTypePDF, sAttachFile That saves the sheet as a PDF. I use the ExportAsFixedFormat method a lot in loops and I get the Run-time error 1004. Document not saved. the document may be open, or an error may have been encountered when saving error every so often. When I get this error I hit Debug and F5 and everything works fine. I know it's a timing issue, but haven't taken the time to figure out how to avoid it. It started happening on this customer email workbook. I couldn't hardly ask a normal user to click Debug, F5, and close the VBE when it's done. I'm not a monster. I put a one second delay before line to allow Windows to have time to release the file lock or whatever the heck is going on. It only executes on about seven of the 100 customers, so it makes a 10 second procedure run in 17 seconds. We can live
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and http://stackoverflow.com/questions/25686203/excel-is-waiting-for-another-application-to-complete-an-ole-action policies of this site About Us Learn more about Stack Overflow the company https://www.experts-exchange.com/questions/28310630/Microsoft-Office-Excel-is-waiting-for-another-application-to-complete-an-OLE-action-error.html Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a ole error minute: Sign up Excel is waiting for another application to complete an OLE action up vote 2 down vote favorite 1 Before you go for the obvious: Application.DisplayAlerts = False has not solved my problem. I have written a VBA procedure (initiated in Excel 2010) which loops around an array containing different Excel files. The loop opens the file, refreshes the excel ole error data, saves and closes the file for each item in the array. I have written an error catch sub routine so I log which excel files have failed to open/refresh/save etc so a user can manually check them. Some files are quite large and involve a large amount of data moving across the network; sometimes I get a dialog box with: Excel is waiting for another application to complete an OLE action. I could use Application.DisplayAlerts = False to disable the message but this would presumably disable all alerts so I couldn't catch the errors? Further I have tested using the line and it doesn't stop the dialog box pop-up. If I press enter it carries on but will likely pop-up again a few minutes later. Is there a way to stop is message specifically without stopping other alerts? NB. My process has a control instance of Excel which runs the VBA and opens the workbooks to be refreshed in a separate instance. Thanks for your help An extract of my code is below which contains the refresh elements Sub Refresh_BoardPivots_Standard() '
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Microsoft Office Excel is waiting for another application to complete an OLE action error Want to Advertise Here? Solved Microsoft Office Excel is waiting for another application to complete an OLE action error Posted on 2013-12-04 MS Excel Windows Server 2008 Networking 1 Verified Solution 7 Comments 15,238 Views Last Modified: 2014-03-29 A user will click on a hyperlink in Excel to access a Microsoft Word Document and they will intermittently get the following error "Microsoft Office Excel is waiting for another application to complete an OLE action". We have run a repair on Microsoft 2010 Office but the problem still occurs. It is intermittent and the system is fully updated. Any assistance offered would be greatly appreciated. 0 Question by:regsamp Facebook Twitter LinkedIn Google Best Solution byregsamp I ended up solving it. It ended up being this issue: http://superuser.com/questions/98983/word-documents-looking-for-template-on-network-drive Go to Solution 7 Comments LVL 40 Overall: Level 40 Windows Server 2008 9 Networking 6 MS Excel 3 Message Active 1 day ago Expert Comment by:Jackie Man2013-12-05 Doc or docx file? 0 Message Author Comment by:regsamp2013-12-05 It will occur with Doc and docx files. 0 Message Accepted Solution by:regsamp2013-12-05 I ended up solving it. It ended up being this issue: http://superuser.com/questions/98983/word-documents-looking-for-template-on-network-drive 0 LVL 40 Overall: Level 40 Windows Server 2008 9 Networking 6 MS Excel 3 Message Active 1 day ago Expert Comment by:Jackie Man2013-12-05 Glad to know your feedback. Cheers! 0 LVL 16 Overall: Level 16 Networking 4 Windows Server 2008 3 MS Excel 1 Mes