Thanks for your post.

I've tried with it but the code like is right now can pass the information at once to excel, because i do some calculation and after that i pass one by one the records to excel.

And in others ocations doesn't pass all the record but just a few.