Sorry for late reply. With delay i am not getting error. But wanted to know if there is any other way apart from using Delay.
I am not accessing files from shared drive
Hi @Ngh_Bui
can you try using Workbook activity like read range workbook activity etc instead of excel application scope activity?
also you can try including kill activity before opening the excel and mark continue on error true in the kill activity
@Ngh_Bui I have occasionally got the same error and was wondering where you added the delay to? I have a Use Excel File activity within an Excel Application Scope which adds some columns and then updates data into those columns. Not sure if the delay needs to be added after each of my Insert Column activities.
Even in my case same issue was occurred now got solved after i increased the delay time,
in my first workflow bot has some excel work which will be closed automatically after work done
in second workflow i have increased delay time then bot has functioning well now without any error
Note: using excel activities only not workbook activities, try increasing the delay time if multiple action will done by the bot.
@nabeelu Try using Kill process activity and provide “excel.exe” before reading or writing the files, if using Modern Activities. You should be good. You can introduce some delays like 5 seconds if activities are sequenced consecutively.
I had the same Issue it seems I had to kill the Excel process before to try to use an excel process (copy paste) So I found a usefull video that solved my problem: