cancel
Showing results for 
Search instead for 
Did you mean: 

Need to automate double click action in Excel using Blue Prism

Shwetavd
Level 4

The requirement is -

If I double click on one cell in excel sheet, it generates 1 new sheet with some data.

I need to automate this.

Options I tried:

  1. In Excel VBO, no direct action is available
  2. Could spy the excel cell in UI mode but not getting double click option in Navigate stage.
  3. Try sending many key combinations in Global Send Key Events (e.g Tab+Enter/F2 keys)

No option is working.

Can anyone please suggest any solution on this.

Thanks & Regards,

Shweta



------------------------------
Shweta Dharmadhikari
RPA developer
Accenture Solutions Pvt Ltd
Asia/Kolkata
------------------------------
4 REPLIES 4

Hi Sweta,

Can you please explain in a bit more detail? You double-click on a cell and it creates a new sheet with data!  I've not seen excel doing such action before.

If possible attach some snaps as well to assist you better.



------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

Mukeshh_k
MVP

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

20345.gif

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

open worksheet by doulbeclick1

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


------------------------------

Regards,

Mukesh Kumar

AaryaP
Level 2

 Need to automate double click action in Excel using code stage in Blue Prism. Can anyone suggest solution.



------------------------------
Aarya P
------------------------------

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

20348.png



------------------------------
Best Regards,
Devendran Venkatesh
RPA - Technical Architect |
Riyadh 11413, Kingdom of Saudi Arabia
Phone. +966-556784162
------------------------------
Best Regards, Devendran Venkatesh RPA - Technical Architect | Riyadh 11413, Kingdom of Saudi Arabia