Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE action error thru automation
Hi, would somebody pls help me this:
I'm trying to write a program from Excel Macro to call Access to run report. but this message keeps popping up while Access trys to export data out into Excel: "!" - Microsoft Excel is waiting for another application to complete an OLE action" click OK what can I do to close this out? pls help! Thanks, ste |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE action error thru automation
Not sure! I would suspect that Access or Excel is encountering a run time error or you are in debug mode in one or both environments. Make both session visible & investigate.
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE action error thru automation
but technically how can I skip that warning message in
order to keep the code running? Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE action error thru automation
I don't think you can skip the warning--it means that further progress is NOT possible.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Action on excel #Reference! error 4? | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Action on Error | Excel Programming | |||
Action on error | Excel Programming | |||
Unknown where is the problem on the Runtime error - Automation error | Excel Programming |