Question

3
Replies
132
Views
kanam Member since 2012 58 posts
ServiceNow
Posted: 3 years ago
Last activity: 3 years 2 months ago
Closed

Click on a field in Excel implemented with ActiveX control

Hi. Can we somehow perform click on the field indicated with the red rectangle in the attached png image? This field is implemented with ActiveX control.

We actually need to set values in the fields in this Excel, and need to click on the button around G2 cell. These objects cannot be interrogated with using the Windows application feature. We though we could do that with using SendKeys method with using {TAB} keys for moving cursors between fields, {Down} keys for selecting the entry from the dropdown menu, and space keys to push the button. To achieve that, we first need to place the cursor to the top left field.

We are using Excel connector with setting StartOnProjectStart to False, with using Windows Appplication for handling Excel as a Windows application at the same time. We tried PerformClick (2 parameters), PerformDoubleClick (2 parameters), and PerformRightClick (2 parameters) to the object at the bottom of the hierarchy in the Object Explorer, which didn't work so far.

Or, do we have different approaches to set values to these fields and to push the button?

The Excel file in this case can be found in the attachment

Thanks,
Moritaka Kanai

***Moderator Edit: Vidyaranjan | Removed Box url and updated content & categories***

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn