D
DomThePom
I have this routine which I developped a couple of years ago to export query
results to Excel. The routine has run fine until recently. What I get now 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. 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. The routine has run fine until recently. What I get now 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. 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!