Question

1
Replies
316
Views
Gar Rasaratnam (GarR3005)
Accenture

Accenture
CA
GarR3005 Member since 2017 7 posts
Accenture
Posted: February 20, 2017
Last activity: March 3, 2017
Posted: 20 Feb 2017 18:02 EST
Last activity: 3 Mar 2017 16:09 EST
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.