Hi All,
Im trying to open file to write multiple sheet with dynamic name in the same excel file. its giving the same error . i tried multiple time with giving delay before opening the file.
please help me on this. advance thank you.
Hi All,
Im trying to open file to write multiple sheet with dynamic name in the same excel file. its giving the same error . i tried multiple time with giving delay before opening the file.
please help me on this. advance thank you.
I did this one but the problem is not solved . for workbook readrange activity also im getting this same error.
Can you open Take manager and kill the excel file if it appears.
Regards
Gokul
Hi Palaniyappan,
i tried with the above suggestion but still facing the same issue. after creating 170sheets or 180+ sheets this error is occurring. i tried with kill workbook and gave 10sec delay.
In my case i need to create news sheets depends on the filters so possibly every file needs to create 200 sheets. to create this its taking almost 3 to 4hrs of time.
Did u try a achieving this with macro @khetawat_Lalitha_Narayan
Hi @khetawat_Lalitha_Narayan ,
Is your resolved if not,
Could you please elaborate what you are trying to do and what is the error message you are getting.
Thanks,
Sandhiya P