Skip to main content
Question

BOT fails when the excel file is opened by another user and locked. How do we get around with this issue? what is error handling method for this? any code can help on this issue to close the excel file by BOT. pls do help on solution.

  • June 10, 2022
  • 1 reply
  • 117 views

BOT fails when the excel file is opened by another user and locked. How do we get around with this issue? what is error handling method for this? any code can help on this issue to close the excel file by BOT. pls do help on solution.

1 reply

Forum|alt.badge.img+12

Hello ,

 

Please try to kill the process with below steps:-

>Open CMD

>Add keystrokes command with parameter 'taskkill /f /im "excel.exe"

>Add keystrokes to Enter

>Now excel should be closed and you can use the new session.

 

If you have any questions please let me know.

 

Thank you,

Prabhakar Jha