I have an access database that copies the results of a query (multiple ones) to Excel using VBA. One of the queries takes a long time to run (maybe 5 minutes). About 1/2 way through the process I start getting a popup message in excel that says "Microsoft Excel is waiting for another applicatino to complete an OLE action"
What can I do to eliminate that message so that it won't popup. The query is running properly and sending the data to excel.
Any ideas on how to suppress this message???