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.

  • 10 June 2022
  • 1 reply
  • 6 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

Userlevel 4
Badge +8

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

Reply