Grouped Shapes or Individual Objects with grouped shapes in Excel.xaml File Like Radio Buttons in Macros

Help Solution Accelerators
, , ,
1

I got an Excel file which had multiple macro sheets and i got some Radio type buttons Which are neither Form control nor Active X buttons from excel but they are clickable like Ui Elements in Excel by manually Since these Radio buttons are Individual Objects with grouped shapes in Excel. I can find them in Home Ribbon Under Find and Next under Control Panel these buttons are visible but I cant able to automate them.

  1. I Used VB scripts but it is not working since these are not Form control or Active X buttons from excel
  2. Tried to use classic and Modern Click activity but getting this error “ERROR HRESULT E_FAIL has been returned from a call to COM component”
  3. I had to achieve this while run time if there is any situation as per requirement the bot had to click these buttons, So Macros are not good for my issue

If any one got any Ideas about how we can achieve this Using UiPath Please let me know

2

Hi @durgaprasad.pilla

Welcome to UiPath,

Try using the click image to identify and click the radio buttons based on a captured image of the button, if that doesn’t work, consider using computer vision or ocr activities to detect the buttons visually and click them.

Happy Automation!

3

@durgaprasad.pilla,

Kindly share more details like screenshot or sample file to analyse

4

Hi @prashant1603765 Thanks for the reply but types that you have mentioned are not reliable and not stable(Since these radio buttons visually looking like UiElements i.e. not), working only once

6

@durgaprasad.pilla

Welcome to the community

  1. On click what is happening is it triggering any macro or updating some data? if so you can do it directly instead of clicking
  2. If click is performed with macro record is it recording anything?
  3. The error on click does not see to be an issue related to ui but some other issue..can you show how you tried and what window and selectors are used

cheers