OLE action error thru automation

[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

 

[Guest]

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.

 

[Ste]

but technically how can I skip that warning message in
order to keep the code running?
Thanks.

 

[Guest]

I don't think you can skip the warning--it means that further progress is NOT possible.