Automation Challenge. This looks interesting.

#21
I was able to crack the blue prism but instead of reading 10 records form the excel bot is only reading records from 2-11 that is 9 records and updating those 9 records in the rpachallenge site.
I am using BP version 5, using open source excel (file name is saved as xls).

From VBO MS Excel using
1. Open Instance
2. Open Workbook
3. Get Workbook As Collection
4. Closing the workbook instance
 
#22
I was able to crack the blue prism but instead of reading 10 records form the excel bot is only reading records from 2-11 that is 9 records and updating those 9 records in the rpachallenge site.
I am using BP version 5, using open source excel (file name is saved as xls).

From VBO MS Excel using
1. Open Instance
2. Open Workbook
3. Get Workbook As Collection
4. Closing the workbook instance
Had made a small mistake rectified it and now it is working fine
 
#23
Had made a small mistake rectified it and now it is working fine
View attachment 1493116862887.png

few observations:
1. when I wrote a dynamic code the amount of time it took to complete the challenge was almost 3 times what it took when I had less efficient code
2. incase I resized or made the webpage go out of focus the data entry part is becoming erroneous
3. the bot capability to write data is also driven by the configuration of the machine it is being executed from and the workload of that machine
 
#29
Guys, really?
Why I would use editor for that?
What I have from fooling you?

That is my result, 310ms is my new record.
I am using Autohotkey.
 
Top