Working with a shared Excel

Hi Guys,

I need some ideas, I need work with a shared excel, but the process sometimes fails when someone else open and close the file in another location.

There is any way to block the excel when the robot is running and unblocked when the robot finish the process?

thanks

Hi @carmen,

I don’t know how your file is shared but you might find some hint below for onedrive. I don’t know if you you have a mean to “kick out” already editing the file but you might detect the situation.

https://sharepoint.stackexchange.com/questions/240958/how-it-enable-check-in-check-out-in-onedrive-business#:~:text=With%20SharePoint%20and%20OneDrive%20for,will%20open%20as%20read-only.

1 Like

Hi @carmen,

One suggestion could be - When we are Reading the excel and the excel is Open - we get an exception saying File is in use by some other Process. -

we put this part in the Try Block - In the Catch Section for Filein use Exception - we can handle it 2 ways

  1. We can create a copy of excel and continue automation with the copied version. At the same time we send an email to the Concerned Team to close it before the Next run.This will Not Break The automation - But You might loose the changes that the person has Done.

  2. We Stop the Process by logging a Message and Emailing to the Team saying Excel was Opened and Process is Terminated. Close the Excel and Re Trigger the Automation.


Mukesh

1 Like

Hi @msan is just a share excel in a share drive.

Hi @mukeshkala thanks for that ideas … I will evaluate it.

1 Like

@carmen
not so far from @msan have a look on this thread:
How do we allow a bot and a user to concurrently edit excel file?

1 Like