BOT fails while using shared excel if some other user accessing the same file.

Question

I have automated one excel related work, Have use one excel spreadsheet as an input file form that file BOT will take all data one by one, But BOT stop working when some other user accessing that same file.

Is it because BOT & any others user trying to save that file at same time ?

Is there any solution to resolve this issue?

rbkadiyam · Accepted Answer

@Bapi 81if the file is read only, you can copy the file from shared folder to local vdi / bot runner.

Bapi 81 · Answer

Thanks for your reply….But we can't move that file to VDI, because along with BOT human also working on that same fileto process Business exception accounts….So, we are not able to move that file to VDI, as a results if someone accessing that file to completeBusiness exception scenarios that time BOTstop working.and if we remove the shared option form excel file then no one able to access that file to complete Business exception scenariosand due to high counts,we are not able to stop the BOT for any other person to complete business exception scenarios….So, is thereany other way toresolve this issue?

Reply

Sign up

Login to the Pathfinder Community

Scanning file for viruses.

This file cannot be downloaded