I know that there are other posts that are similar in topic but this is something that I want to raise at this point in time. My bot feels really slow especially when it comes to window switching and it kinda falls short of the expectation of what RPA is supposed to be able to do.
I am working on a bot which involves manipulating data from multiple excel windows. It needs to move between excel files in order to retrieve data from cells and it has to deal with a lot of the popup windows and menus. I am not able to use the native excel functions because they are not sufficient for my current use case. As a result of this, it becomes necessary for the bot to handle different windows so that it knows what actions to perform on which window, but there is a performance drawback.
Things that I’ve tried to do from other similar posts of the forum to improve bot performance:
- optimize the flow of actions within the recording.
- adjust RPA recorder settings, delay between action is set to 0ms and switch window timeout is set to 250ms.
- Tried to compile and export the recording into a bot task where the code can be executed. I did notice that there are multiple sleep() actions in between each function and I am not sure where and how these numbers are configured. In addition, I get a compile error: code is too large, probably something to do with a method exceeding 64kb in size. Still trying to figure out how to refactor the code to get it to compile.
Is anyone else facing the same problem?