When I started using the macros in excel file, vlookup got a lot slower than my previous automation is there a way to speed things up again ?
I am handling hundreds of data row per sheet and it takes a lot of time to finish the vlookup
When I started using the macros in excel file, vlookup got a lot slower than my previous automation is there a way to speed things up again ?
I am handling hundreds of data row per sheet and it takes a lot of time to finish the vlookup
Instead of having macro in excel…save them as text file and use invoke vba activity so that macros are not in the file
Cheers
I am not aware of using invoke VBA do this activity has a tutorial ?
Just save the macros in a vba file…
Then in invoke vba you need to provide the filepath and macro name and if any inputs as needed
Check below
https://docs.uipath.com/activities/other/latest/user-guide/invoke-vba
Cheers
Consider using a more efficient data structure, such as a DataTable or Dictionary, to hold the lookup values in memory. This can allow for faster access and retrieval of the lookup values.
Thanks!!!
I am using StudioX.
it is different in the video u provided