Hi Shweta,
That cell probably is invoking a macro code written behind it which means you can look for the code behind it and try running the specific macro from the process and use : MS Excel VBO action - Run Macro when replicated it should look something like this :
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Range("B1")) Is Nothing Then
Sheets("sheet2").Activate
End If
End Sub
You can search for code in that cell as below it will route you to the specific macro behind that cell and you can even activate the cell inside the code itself or Action - Go to Cell and then use custom code to activate it
You can even do : Use MS Excel VBO - Go to Cell Action and then use a custom action for activating that cell and then send the global send keys for double clicks. For activating a cell - you can customise the code in a new action as below :
Sub MakeActive()
Worksheets("Sheet1").Activate
Range("A1:D4").Select
Range("B2").Activate
End Sub
------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.
Regards,
Mukesh Kumar - Senior Automation Developer
NHS England, United Kingdom, GB
------------------------------
Hello,
In case if your unable to spy anything via blue prism, please try below approach as a last option if the excel file is always same.
whatever excel cell if you want to double click, develop a macro by using recording option and later execute the macro file by using below blue prism utility
------------------------------
Best Regards,
Devendran Venkatesh
RPA - Technical Architect |
Riyadh 11413, Kingdom of Saudi Arabia
Phone. +966-556784162
------------------------------
