Hi there,
We have an Excel macro that takes about 2 or 3 seconds to execute when doing it manually. But when the robot does it it takes up to a minute or more. We are executing the macro via UI.
This is a huge problem because we have to run this macro many times within a execution.
Has this happened to anyone else? Any solutions?
Hello @Gines_Cirera
You can try VBA code. or open the excel and do send shortcut keys (hotkeys with alt.)
Hi,
We are already executing the macro with hotkeys (alt+F8 to open the “View macros” window and then selecting the macro).
We can also simply press a button that triggers the macro but it does not change anything, in both cases the macro still takes way too long compared to manual execution.
any thing you are doing in the vba like formatting you must be chnging the range of string to number thats why it is taking time. but you can try by providing that same formatting by open excel and send multiple hotkeys like ctrl+a for select all ctrl+b for bold for going to randome column try ctrl+g and trype the column name then send hotkey like ctrl+shift+end to select data till end then do the formatting. it will not take time. you can send using alt button also.
Hello @Anil_G @Yoichi is there any solution for this please support.
Why not use execute macro and why are you sending a key combination and all?
excels are not for ui interaction and that is the reason a execute macro and many activities for excel have been provided did you happen to try them?
cheers
@Anil_G
He is running with micro only then only it is taking more time.
Check this.
Execute macro is an activity…not by using shortcut or invoke methods
They are dping through ui I believe
Cheers