Microsoft Excel and OLE action

  • Thread starter Thread starter lbruner
  • Start date Start date
L

lbruner

I wrote a macro that opens an access database, and updates based on som
information from an ORACLE table. I have to run a loop that can tak
several minutes and I continue to get the pop "Microsoft Excel i
waiting for another application to complete an OLE action" I need t
be able to turn that pop up off. It is an informational warning, an
it does not turn off by using DoCmd.SetWarnings FALSE

Thank
 
Consider an alternative approach e.g. use ADO within you Excel macro
to execute update stored procedures/queries against the Oracle/MS
Access data sources.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel waiting for OLE action - how to resolve 0
Excel waiting for OLE action - driving me crazy. Help appreciated 1
OLE Problem on Opening 1
OLE action? 3
OLE action error thru automation 3
waiting for another application to complete an OLE action. 1
Waiting for OLE action 2
Waiting for an OLE Action 1

Back
Top