Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sivasankaran Ganesan (Siva_G)
Accenture
RPA Architect
Accenture
IN
Siva_G Member since 2023 14 posts
Accenture
Posted: Apr 16, 2020
Last activity: Apr 16, 2020
Posted: 16 Apr 2020 6:21 EDT
Last activity: 16 Apr 2020 11:18 EDT
Closed

Robotics - Interact with VBA form

Hi Team,

I am facing challenge to interact with Excel VBA form.

VBA windows form will appear upon opening the excel and the business case is to interact with that form.

I have tried using Windows adaptor and Excel connector. But it won’t interact with that form.

Anyone have any idea?

Thanks

***Edited by Moderator: Pallavi to change content type from Discussion to Question***  

To see attachments, please log in.
Robotic Process Automation
Other Industry
Solutions Consultant

Posted: 4 years ago
Posted: 16 Apr 2020 10:15 EDT
Jeff Badger (jeffbadger)
PEGA
Principal Product Manager, Robotics
Pegasystems Inc.
US

Is this for attended or unattended? With unattended you could use ScreenOCR. The help system has details and you can find that here.

To see attachments, please log in.
Posted: 4 years ago
Posted: 16 Apr 2020 11:18 EDT
Sivasankaran Ganesan (Siva_G)
Accenture
RPA Architect
Accenture
IN

Its RDA bot. It contains 6/7 tabs, many textbook and dropdown boxes.

Tab alignment is not in proper order too, in order to select the next controls.

Unable to interrogate all the controls.

Thought to use sendkeys and ClickbyText methods, but often it failed to perform correctly.

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice