Need help in Excel issue

Hi,

I have created a process which has excel recording. Sometime, excel is getting stuck due to 1004 error and because of this next execution is failing. Is there any way to kill OR close excel after the process execution?

Hi,

There are two possiblities:

  1. If you have recorded file opening step in excel recorder then you will have to record file close step also.
  2. Else if excel file is in open state before excel recorder has been used then you can use File Operation - File close activity

Regards,
Amit Anand

Hi Amit,

I have recorded all the steps but the problem is when we get 1004 error, it will get stuck until and unless we give some input manually.
It is a rare case.Can you please suggest a way to kill excel automatically so that next execution will work properly.

Hi,

If it is a rare scenario handle the same using try catch block. Write a microbot to kill excel process in catch block

Regards,
Amit Anand