OLE action error thru automation

  • Thread starter Thread starter Ste
  • Start date Start date
S

Ste

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
 
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.
 
but technically how can I skip that warning message in
order to keep the code running?
Thanks.
 
I don't think you can skip the warning--it means that further progress is NOT possible.
 
Back
Top