ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel waiting for OLE action - how to resolve (https://www.excelbanter.com/excel-programming/424980-excel-waiting-ole-action-how-resolve.html)

Tom Joseph

Excel waiting for OLE action - how to resolve
 
I am using Excel VBA to create and email PDFs using Outlook,

The code that follows generally works, but on occasion I get:
Microsoft Office Excel is waiting for another application to complete an OLE
action.

I hangs here (first line):

Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)

Are there any workarounds or other ways of making this process more reliable?

Thanks,


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

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