Excel file : Sometimes it opens and sometimes it fails

Hi ​@anshit ,

Could you please provide a bit more details on what you are trying to achieve with your automation?

I am creating a sheet containing PNL for several departments(18) using a loop.

When I am running it via developer login ,it works fine.

However, if I run it via runner it fails after calculating PNL for 5-6 departments and gives the above error.

Are you using Recorder action within Excel for this?

If yes, can you please share the reason of not using the Excel package instead?

Can you help me with the Line number where you are getting this error? Additionally, try after changing the Excel Package version.

Started on

11:15:08IST

2025-05-05

Ended on

11:32:03IST

2025-05-05

Last state

27%  |  Line 130 of 475  |  Failed

Last bot

Auto_MIS

Last action

Keystrokes

Error message:

There was a problem at line 130 This may be due to the following reason: Unable to activate the window with this title(com.automationanywhere.botcommand.data.impl.WindowValue@665e79f8). Verify that the window is opened.

Location: General_MIS_developer (line 130)

To continue, edit the bot and fix the error. Then, try again.

If you continue to see this message, please contact your system administrator.

As per the shared code, I can see that you are trying to paste the clipboard data into Excel on line 130. Could you please add some delay in between 129 & 130 and try again? Since the bot is trying to execute both actions within fraction of seconds, you may face such issue especially in the unattended automation.