Hi,
I am using Write Cell Workbook activity many times one after another.
Very often I get this error:
The process cannot access the file ‘A:\xxxx.xlsx’ because it is being used by another process.
Another process is meant the previous Write Cell Workbook activity.
Any suggestions how to avoid it?
Thx and king regards, Vanja
The error means the excel file is opened and workbook activity can’t access file which is being used or which is opened make sure you kill the excel file before using write cell workbook or if you’re using excel activities not the workbook activities the use only that or use only workbook activity don’t combine both.
Cheers
Adding this write cell workbook logic inside Retry scope should help you.
Also if possible, try using Excel activities which will avoid opening the file multiple times.
Leave it blank and change the Number of retries and Retry Interval as per your observation which is failing and which is working. If 3 second delay not sufficient, you can try increasing it.
Leaving the condition blank will work like this: If any error occur within the scope, it will retry. If no error, it will continue execution of the next activity without checking any condition.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
