waiting for another application to complete an OLE action.

M

Marc W

Hello,
I am working on having macro in Excel 2003 run a macro in a MS Access
database. The macro in access runs make-table queries from linked SQL
tables. All is fine except I keep getting the following message when the
access macro is running: "Microsoft Office Excel is waiting for another
application to complete an OLE action". This of course stops the macro and
requires manual intervention to click the OK button.

Does anyone know how to get around this message box so that it will run
completely without manual intervention?

Thanks!
 

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

Top