Microsoft Excel and OLE action
 

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

--
Message posted from http://www.ExcelForum.com

Microsoft Excel and OLE action
 

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.

--

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

Thanks


---
Message posted from http://www.ExcelForum.com/