Bot is getting freeze after it runs the Macro


Hi folks, i have observed that the bot is getting freeze or deadly slowed down once it run the macro in Excel using Invoke VBA

Is there any solution / step i can perform to overcome the issue

my Studio version is 2019.4.2

Hi @vinay_reddy,
There were some similar topics. I guess the case is that you are doing operation on excel directly. The fastest method is to keep all data in datatable and operate on this. Here are some tips from one of the topic: