Error Excel Form

Help
, ,
1

Hi
Im having a issue with the combo box of a excel form because the activite “Select Item” show me an error

image
image1707×806 62.5 KB

With the next error
Select Item ‘editable text’: Error HRESULT E_FAIL has been returned from a call to a COM component.

Theres a way to fix it or a plugin to use?

2

@ing88feracmo

Use two Click activities.

  1. First click is to click drop down list.
  2. And second click is to Select Item from drop down list and make this Selector dynamic by passing variable into Selector to Select different items in list.
3

Hi @ing88feracmo

Instead of using select item you can use click activity
There you can pass variable

Example of Using a Dynamic Selector

To illustrate the functionality of a dynamic selector, we create a simple automation process which performs a click on the File menu in Notepad. We then change the variable so that the Format menu is then clicked, but without modifying the selector.

Note:

The following example uses a variable . Please note that arguments are also supported.

  1. Create a new process in Studio, and add a Click activity.
  2. Choose to Indicate on screen and select the File menu in Notepad. The following selector is generated:
<wnd app='notepad.exe' cls='Notepad' title='Untitled - Notepad' />
<ctrl automationid='MenuBar' idx='1' name='Application' role='menu bar' />
<ctrl name='File' role='menu item' />
  1. Select and right-click the File property of the name attribute. A context menu with several options is displayed.
  2. From the context menu, choose to Create variable . A couple of fields appear, allowing you to specify the variable name and value.
  3. Specify a name for the new variable in the Set Name: field, which, in our case is MenuOption . Leave the Set Value field as is, so that the selector knows to click the attribute with the File property.
  4. Click the Validate button in the Selector Editor window. Notice it turns green, which means our selector is valid. As such, the following dynamic selector is generated:
<wnd app='notepad.exe' cls='Notepad' title='Untitled - Notepad' />
<ctrl automationid='MenuBar' idx='1' name='Application' role='menu bar' />
<ctrl name='{{MenuOption}}' role='menu item' />

The generated selector now instructs the Click activity to perform the action on the File menu. To have it click the Format menu, for instance, you only need to change the default value of the variable. In this example, the operation requires a single step:

  • Access the Variables panel in Studio and change the Default value of the MenuOption entry to Format . The Click activity now performs the action on the Format menu in Notepad. Note that the selector is already validated and you can start your automation process, which now clicks the Format menu instead of File .

Cool,
Regards,
Gulshiyaa