Handling of input Excel .

[YogeshBarge]

Hi Guys , I have an exception scenario where , if the Input Excel is being filled just before bot run , then I want the bot to wait till the excel is saved . Try this 2-3 times and end . Currently I don't see any action where we can find out if the excel is opened by another user . ( We have a shared drive where the business is expected to update this input excel ) . OLEDB is also not throwing an error while try to read an already open excel as I presumed it to be . Is there any current action which I can use by using that stage's particular error string to find out that the excel is actually opened and use this in a loop till that error is not caught stating the excel has been saved and closed . This is one approach I feel I can go for . Any other ideas or solution please .   Regards, Yogi.

[Anonymous]

Hi Yogi,   You can use decision post open workbook if it's already open then you can throw exception or anything want you want to do or you can use sleep. But the best solution is if the file is placed in shared drive and that file is used by multiple process I will suggest to use ""Enviroment Locking"" concept by using this if the file is already in used then you will get exception.