Office Excel Is Waiting for another Application to complete an OLE Action

[chinmay_uce02]

Topic\Err Msg : Office Excel Is Waiting for another Application to
complete an OLE Action .


Description : Hi,

I am copying Large Recordsets to the another Excel File ( nearly 4.3 MB in C:\ Drive) using Excel VBA Automation Objects ( oBook ,oExcel and CopyFromRecordset method ) with fields name.
The error written above is showing on executing the piece of Code in VBA. I am creating Recordset every time with the queries and then using a loop to write the fields name in the Target Excel Sheet in C:\ drive and then using CopyFromRecordset method to copy the actual data in the target excel sheet. Though i m setting the oExcel ,oBook = nothing at the end of the code.

Thanks
chinmay