Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
waiting for another application to complete an OLE action.
Hello,
I am working on having macro in Excel 2003 run a macro in a MS Access database. The macro in access runs make-table queries from linked SQL tables. All is fine except I keep getting the following message when the access macro is running: "Microsoft Office Excel is waiting for another application to complete an OLE action". This of course stops the macro and requires manual intervention to click the OK button. Does anyone know how to get around this message box so that it will run completely without manual intervention? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
waiting for another application to complete an OLE action.
FYI - 'application.displayalerts = false' resolved my problem.
"Marc W" wrote: Hello, I am working on having macro in Excel 2003 run a macro in a MS Access database. The macro in access runs make-table queries from linked SQL tables. All is fine except I keep getting the following message when the access macro is running: "Microsoft Office Excel is waiting for another application to complete an OLE action". This of course stops the macro and requires manual intervention to click the OK button. Does anyone know how to get around this message box so that it will run completely without manual intervention? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel is waiting for another application to complete an OLE action | Excel Discussion (Misc queries) | |||
Microsoft Office Excel is waiting for another application to complete an OLE action | Excel Programming | |||
Error msg "Microsoft Excel is waiting for another application to complete an OLE action" | Excel Programming | |||
Waiting for app to complete OLE action | Excel Programming |