Question

1
Replies
299
Views
GarR3005 Member since 2017 7 posts
Accenture
Posted: February 20, 2017
Last activity: March 3, 2017
Closed
Solved

Unable to interrogate Excel VBA Application form controls

Hi,

I'm trying to interrogate a VBA Application UserForm that's built in Excel, however I am unable to do so. I believe the UserForm controls may be normal Form controls or Active-X ones (not too sure). The UserForm automatically launches when the workbook is launched. This is an example of a UserForm: http://chandoo.org/wp/excel-vba/user-forms/

When I use the windows adapter and try to interrogate it, the UserForm window is be recognized, but the specific controls like the textbox and dropdowns are not being recognized.

Also, in this particular case where I need to open the XLSM file (macro-enabled workbook) using a windows adapter, how should I use Excel.exe as the Path?

Am I going about this all wrong and should I be tackling this problem another way?

Thanks in Advance,
Gar

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