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!
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!