SAP OLE to Excel - Record miss problem

Hi Experts

I am using SAP OLE to transfer records from SAP to multiple sheets of Excel.

Everything is going fine, except that randomly some records get missed while transferring to MS-Excel. This is the problem. However, the same program works pretty smoothly without any hitch when using Open Source platform like WPS Office. If there was any problem with the SAP code, nothing would have got transferred.

Is there anything amiss?

Many thanks