Best practices to change VBA Macro code to Uipth Code so it takes less time to complete the process

Help Studio
, ,
1

Best practices to change VBA Macro code to Uipth Code so it takes less time to complete the process
@Kavi_Priya @mukeshkala @RAKESH_KUMAR_BEHERA

2

@Akshay_Gaikwad

Welcome to the community

  1. Vba will be generally faster than the excel activities we use but can try to use workbook activities if they support and can check the speed
  2. Instead of using execute macro we xan convert the vba code to vb script and then use invoke vbs activity which can be little faster
  3. I hope on error has already been implemented in vba if not it is better implement error handling using on error and goto
  4. For conversion you can try using chatgpt or if you are on latest studio you have UiPath co pilot as well

Hope this helps

Cheers