How to check any Excel file is opened by another user in shared path?

[anishakotian400]

How to check Excel file is opened by another user in shred path without opened excel file,
if it is open want to get file name
please Help

[Srini84 (Srinivas)]

@anishakotian400

Check below post for your reference

Check if Excel file is being used

Continuing the discussion from Check if file is occupied: Hello, I’m getting an error message from the Read Range activity: The process cannot access the file XXX because it is being used by another process. I would like to check whether the file is in use and have found the link to the TryCatch check file.Open(FileMode.Open, FileAccess.Read, FileShare.None), but I don’t know where to put that setting. So far I have the following: [Capture] EDIT: I don’t want to KillProcess as I don’t mana…

Hope this may help you

Thanks

[Palaniyappan (Forum Leader)]

Hi

This thread has a similar scenario and a solution as well

Hope this would help you

How to check if file in Sharepoint is opened by another user

Hello @danlicka! It seems that you have trouble getting an answer to your question in the first 24 hours. Let us give you a few hints and helpful links. First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic. You can check out some of our resources directly, see below: Always search first. It is the best way to quickly find your answer. Check out the [image] icon for that. Clicking the options button will let you set m…

Cheers @anishakotian400

[anishakotian400]

did not find correct solution, can you help with other solution?

[postwick (Paul)]

Put Excel Application Scope inside a Try/Catch. If it fails, you can check the error message to see if it’s locked.

[anishakotian400]

Can I get any example

[pravin_calvin (pravin kumar)]

Hi @anishakotian400

Use Try catch and make the exception in catch as IO exception!

If the file is open, then it will throw the IOException and will move into your catch block and perform any you put there. If it is not open, it will simply move onto the next activity outside of your try-catch block!

Please refer to the xaml below! @anishakotian400

Main.xaml (9.3 KB)

Regards