Help me please write cell error

Error wrire cell in loop round 2

If I run round 1 It work completed.
But in loop round2 it error as below.

I think it not create sheet new (Nov2020).

Please guide me about it.

image

Hi @fairymemay

Can u show what I write using write cell

Strating from CDate part?

Hi @fairymemay ,

It is usually not recommended to go with Loop for writing to an same excel, if it is possible kindly add details to data table and finally use write range.

In this scenario it seems you are opening the excel in loop, kindly use excel application scope outside loop, and then use loop just for write cell(if write range doesn’t fit here).
Close the excel workbook once you are done using, some times the excel process stays as an residue.