- Joined
- Nov 8, 2006
- Messages
- 2
- Reaction score
- 0
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
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