ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error msg "Microsoft Excel is waiting for another application to complete an OLE action" (https://www.excelbanter.com/excel-programming/288155-error-msg-microsoft-excel-waiting-another-application-complete-ole-action.html)

JimPNicholls

Error msg "Microsoft Excel is waiting for another application to complete an OLE action"
 
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?


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com