Error in Export: "Microsoft Office Excel is waiting for another ......."

  • Thread starter DomThePom via AccessMonster.com
  • Start date
D

DomThePom via AccessMonster.com

I have this routine which I developped a couple of years ago to export query
results to Excel.

I use a custom routine so I can add titles etc, format the data as required
and create pivot tables in Excel on the fly.

The routine has run fine until recently.

However, what I get now for large data exports is mid-way through the export
a dialog appears in Excel with the message:

"Microsoft Office Excel is waiting for another application to complete an OLE
action".

Clicking on the OK button in the dialog makes it go away for while, but then
it comes back.

Sometimes, by repeated clicking on OK , I can get the export to complete,
though this is in the minority of cases. Neither can I break into the code.
The only way to get rid of the dialog is then to do a
ctrl alt delete and end the Access task. The dialog then disappears on the
next click. However, not all data has been exported.

I have tried to turn off excel's 'displayalerts' property (xlapp.
displayalerts = false) but this does not seem to work

We are using Access 2000 and Excel 2003 - we moved from Excel 2000 recently
so this may have something to do with it. Any assistance would be greatly
appreciated!
 

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